View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don G Don G is offline
external usenet poster
 
Posts: 13
Default Find Last Column??

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