<div>
Thanks - I figured it would be easy but could quite get the syntax right.
</div>


<div>
<pre><code id="code-20-39295016-1">Sub CopyRange()
Dim newRange As Range
Set newRange = Worksheets(1).Range(&quot;A1:Last_Print_Cell&quot;)
newRange.Copy Destination:=Worksheets(2).Range(&quot;A1&quot;)
End Sub</code></pre>
Replace your sheet names and destination with what is appropriate for your workbook.<br />
<br />
Regards
</div>


<div>
You're welcome, <i>girbeaud</i>.
</div>


<div>
I don't expect any points but better would be<br />
<br />
Range([A1],[Last_Print_Cel<wbr />l]).Copy
</div>


<div>
Your suggestion doesn't both select &amp;&nbsp;copy the range though, Martin, as the question required :)
</div>


<div>
<div class="content wysiwyg-content">
I want to copy a range from one workbook to another. &nbsp;The range that I want to copy will always have Cell(1,1) as the top left cell of the range. &nbsp;The location of the bottom right cell of the range will always be different, BUT it will always have the name &quot;Last_Print_Cell&quot; assigned to it.<br />
<br />
How do I select and copy that range using VBA code?<br />
<br />
Thanks!
</div>
</div>


I want to copy a range from one workbook to another.  The range that I want to copy will always have Cell(1,1) as the top left cell of the range.  The location of the bottom right cell of the range will always be different, BUT it will always have the name "Last_Print_Cell" assigned to it.

How do I select and copy that range using VBA code?

Thanks!

Thanks - I figured it would be easy but could quite get the syntax right.

(CODE)
Replace your sheet names and destination with what is appropriate for your workbook.

Regards

I don&amp;#39;t expect any points but better would be

Range([A1],[Last_Print_Cell]).Copy

Your suggestion doesn&amp;#39;t both select &amp;amp; copy the range though, Martin, as the question required :)

Excel 2010 VBA code to select a range using existing Cell names

I want to copy a range from one workbook to another.  The range that I want to copy will always have Cell(1,1) as the top left cell of the range.  The location of the bottom right cell of the range will always be different, BUT it will always have the name &amp;quot;Last_Print_Cell&amp;quot; assigned to it.

How do I select and copy that range using VBA code?

Thanks!

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