View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Find maximum row count of data

How would I find the last (bottom row) of data when data may be missing in
some columns? I'm trying to set Chart options on the run with macros instead
of setting the bottom row to a default value such as row 1000. The number of
rows is changing depending on options picked from a ListBox.
Thanks Steve