Row Number in each Sheet

mkutti

• March 27, 2010 00:00

• Answered

Follow

Hi,

I have a need to get the row number of the sheet(s) in Excel File. Autofilling - global_row_count,sheet_row_count and metadata_row_count are not reset for each sheet. Is there a variable to get the rownumber in the sheet?

I am thinking to check the sheetname change and reset a global variable. If there is a better way, please let me know.

Thanks very much for your support.

• 

  avackova

  • March 29, 2010 08:44

  0

  Comment actions Permalink

  Hello,
  there is no auto-filling function for for the requested value. Your solution is proper.

Please sign in to leave a comment.