last used cell incolumn


Posted by MAX JOHNSON on February 04, 2002 7:50 PM

why does the following find the last used cell in a column only some of the time. sometimes it doesn't work. is there a sure fire way to find the last used cell in a column?

Range("A3").Select
Selection.End(xlDown).Select



Posted by Richard S on February 04, 2002 8:27 PM

see 19948.html (nt)