View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lorne[_2_] Lorne[_2_] is offline
external usenet poster
 
Posts: 44
Default Worksheet Dimensions

Using the keyboard Ctrl-End will go to the bottom right cell in the sheet
(ie lowest row with anything in it and furthest right column with anything
in it, anything being data or a format setting) if that helps you.


"Paul Ilacqua" wrote in message
...
What is the best way to get worksheet dimension for worksheets with non
contiguous rows and columns. The dimensions vary sheet to sheet.

Thanks
Paul