<div>
What worksheet are you using in line 3? &nbsp;Is MySheet the current sheet, or something else? &nbsp;The range depends on the worksheet, so the syntax would be like this:<br />
<br />

<pre><code id="code-20-41754139-1">   strRange = &quot;A7:A10&quot;
   Set rngPipeline = shtPipeline.Range(strRange)
   rngPipeline.Select</code></pre>
</div>


What worksheet are you using in line 3?  Is MySheet the current sheet, or something else?  The range depends on the worksheet, so the syntax would be like this:



   strRange = "A7:A10"
   Set rngPipeline = shtPipeline.Range(strRange)
   rngPipeline.Select

<div>
Perfect!! &nbsp; &nbsp;Thank all for helping.
</div>


<div>
You're welcome. Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Hi.<br />
<br />
I am having problems getting this right. &nbsp; &nbsp;Thank you for your help.<br />
<br />

<pre><code id="code-10-28963065-1">    Dim ws As Worksheet:  Set ws = Worksheets(&quot;MySheet&quot;)
    Dim CCC As Range
    Set CCC = Range(Cells(1, 1), Cells(1, 7))                       ' Seems OK
    Set CCC = Range(ws.Cells(1, 1), ws.Cells(1, 7))                 ' Computer gets angry</code></pre>
</div>
</div>


Hi.

I am having problems getting this right.    Thank you for your help.

(CODE)

Set a  range to another worksheet using R1C1 format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.