Select Range Using R1C1

Try:

Range(.Cells(LastRow+1,13),.cells(LastRow2,LastColumn).Select

Noting that you rarely need to select.

HTH,

Smitty, thanks!!!

I'm using this code to copy a dynamic range of cells. I'm getting an error.


The error is "select method of Range class failed". Can someone advise? Thanks!

Can you show where you're setting your variables?

Because this works just fine:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> foo()<br>    <SPAN style="color:#00007F">Dim</SPAN> ws <SPAN style="color:#00007F">As</SPAN> Worksheet<br>    <SPAN style="color:#00007F">Dim</SPAN> ReceiptsLastRow <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN>, ReceiptsLastRow2 <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN>, LastColumnD <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>        <br>        <SPAN style="color:#00007F">Set</SPAN> ws = Sheets("Sheet1")<br>        <br>        ReceiptsLastRow = 10<br>        ReceiptsLastRow2 = 10<br>        LastColumnD = 10<br>    <br>        <SPAN style="color:#00007F">With</SPAN> ws<br>            .Range(.Cells(ReceiptsLastRow + 1, 13), .Cells(ReceiptsLastRow2, LastColumnD)).Select<br>        <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br>    <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>