Thread: ActiveSheet.UsedRange.Rows.Count = 5002? why?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buffyslay Buffyslay is offline
external usenet poster
  
Posts: 40
Default ActiveSheet.UsedRange.Rows.Count = 5002? why?
hi there

my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only
using 1 (cannot set to one as in future this will be dynamic...)

any ideas?

Reply With QuoteReply With Quote