An application I work on has a reporting engine that uses Excel for report templates. When a report is generated, the code adds a "Data" worksheet to the Excel template, and populates it with named ranges of tabular data. User-defined template worksheets can then use formulas such as VLOOKUP and MATCH to reference and display values from the Data worksheet's named ranges.
For a particular template I needed to get the maximum value of a column of numbers in one of the Data worksheet's named ranges. The problem I ran into was that I didn't know at what row the named range would start, and how many rows it would have, because each time the Data worksheet generates, the various named ranges could have a different number of rows.
For a particular template I needed to get the maximum value of a column of numbers in one of the Data worksheet's named ranges. The problem I ran into was that I didn't know at what row the named range would start, and how many rows it would have, because each time the Data worksheet generates, the various named ranges could have a different number of rows.