Tom,
That only selected the first row. I want the last row.

Thanks,


"Jim Thomlinson" wrote:

Sorry about that. I misread what you wanted... How about this...

Range(ActiveSheet.Range("A65535").End(xlUp),
ActiveSheet.Range("A65535").End(xlUp).Offset(0, 26)).Select

HTH

"Jeff" wrote:

Jim,
That selects everything. I am trying to select some columns only on
just the last row.
Even though i m trying to select the last row of colA to ColZ... there are
actually more than 26 columns containing data. I am not trying to select
everything (columns) on the last row.

Thanks,

Jeff


"Jim Thomlinson" wrote:

Give this a try...

ActiveSheet.UsedRange.Select

HTH

"Jeff" wrote:

Can someone please tell me how I can do the following?
I need a vb code to select last non-empty line of cells from Col A to Col Z.

E.g. I have data from A1:Z107, I need to select A107:z107

Thanks.