Thread: Determining the row limit in a macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Determining the row limit in a macro
MaximumNumberOfRows = ActiveSheet.Rows.Count

--
Rick (MVP - Excel)


"Phil Hibbs" wrote in message
...
How can a macro determine what the maximum number of rows is in the
version of Excel that is running? I don't want to just hard-code
version numbers, and I don't want to use .end(xldown) either.

Phil Hibbs.

Reply With QuoteReply With Quote