I have the same column name in each of about 20 sheets in my Run Time workbook.
I want to cycle through them and collect the value in the first row in same column.
I can probably get to the data with:
How do I get the name of each sheet when I reference it by a number in the second parameter?
mSheetCount = DataTable.GetSheetCount
For ThisSheet = 1 To mSheetCount
mValue = DataTable("Happy",ThisSheet)