View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David Godinger[_2_] David Godinger[_2_] is offline
external usenet poster
 
Posts: 15
Default VBA for Selecting Last Row in Range

The macro took me to the last cell (the lower right of the entire range). By the way, the lower half of the range had no text or numbers in it.

However, there was formatting in all cells of the range for color, number, and border. Could it be that the macro considers the formatting as data? If so, would it be possible for the macro to work only on numbers, dates, and text?

Thanks!

Dave G.