Select Range Using R1C1

[Dathan Camacho]

Hi, I need some help with syntax.

Assume I have 3 variables successfully defined and working:

LastRow1 (original last row before new data pasted)
LastRow2 (new last row after new data pasted)
LastColumn

I'm trying to select the range of cells starting with column 13 and letting the other part of the range be defined by these variables. I.e. I want to select:

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

Can someone help me with the syntax?

 

[Smitty]

Try:

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

Noting that you rarely need to select.

HTH,

 

[Dathan Camacho]

Smitty, thanks!!!

 

[Dathan Camacho]

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

.Range(.Cells(ReceiptsLastRow + 1, 13), .Cells(ReceiptsLastRow2, LastColumnD)).Select

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

 

[Smitty]

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>