View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shinya Koizumi Shinya Koizumi is offline
external usenet poster
 
Posts: 7
Default max row and max col

How to find out the maximum row and col in the current worksheet without
going to the actual cell?

I know if i actually go to the last cell i can find out.

Selection.End(xlToRight).Select