View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patricia Shannon Patricia Shannon is offline
external usenet poster
 
Posts: 56
Default How to get actual rows number in Excel using VBA?

In a situation where that doesn't work, delete the extra rows (and/or
columns) using Edit/Delete, than Save. Sometimes I have to do a Save As.
You can use Ctrl+End to see what Excel sees as the end of the used range.

" wrote:

Got it!
Thank you very much, Dales!
It really helps!

michael