Select Dynamic Range

[Dathan Camacho]

Hi, I need some help with syntax. I need to select a dynamic range using 3 variables.

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 the range:

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

Can someone help me with the syntax?

 

[VoG]

Duplicate http://www.mrexcel.com/forum/showthread.php?t=514171