Hi Folks,

I use the following to find the last row used:

cells(rows.count, "A").end(xlup).offset(1,0).select

Question: is there a similar step for finding the last Column used starting
from the end of the Column and working back? This, of course, is to avoid an
empty Column from stopping the procedure when searching from left to right.

TIA,

Don

for a specific row

cells(1,256).End(xltoLeft).offset(0,1).Select

--
Regards,
Tom Ogilvy


"Don G" wrote in message
...
Hi Folks,

I use the following to find the last row used:

cells(rows.count, "A").end(xlup).offset(1,0).select

Question: is there a similar step for finding the last Column used
starting
from the end of the Column and working back? This, of course, is to avoid
an
empty Column from stopping the procedure when searching from left to
right.

TIA,

Don

Thanks Tom...appreciate the answer.

Don

"Tom Ogilvy" wrote:

for a specific row

cells(1,256).End(xltoLeft).offset(0,1).Select

--
Regards,
Tom Ogilvy


"Don G" wrote in message
...
Hi Folks,

I use the following to find the last row used:

cells(rows.count, "A").end(xlup).offset(1,0).select

Question: is there a similar step for finding the last Column used
starting
from the end of the Column and working back? This, of course, is to avoid
an
empty Column from stopping the procedure when searching from left to
right.

TIA,

Don