What's the best method to aquire the identifying number of the active sheet within a DataTable (instead of the sheet name)?
Currently, this is the only way I've been able to get it:
<font class="small">Code:</font><hr /><pre>Function GetSheetNumber
For i = 1 to DataTable.GetSheetCount
If DataTable.GetSheet(i).Name = DataTable.LocalSheet.Name Then
GetSheetNumber = i
It just seems too crude! Any suggestions??
Re: Aquire a localsheets number instead of its name?
I would like to store some values for each sheet within an array. So, to reference the value within the array, I'm using the corresponding sheet number. Using an array has been simple, since there's no need to worry about the number of sheets or their names.