View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Find Last Column??

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