earldunning
Active Member
- Joined
- Nov 9, 2006
- Messages
- 263
I know how to get and use the worksheet names but is there a way to get the sheet number?
For example, a sheet might be named "raw data" but the underlying object name is really "sheet4" which is used in VB Project/objects.
How can I get the "4" ?
I am trying to attach some code within a sheet so that I can use it when I copy the sheet and create a new workbook.
see my other link regarding macros creating macros -
http://www.mrexcel.com/forum/showthread.php?t=380307
For example, a sheet might be named "raw data" but the underlying object name is really "sheet4" which is used in VB Project/objects.
How can I get the "4" ?
I am trying to attach some code within a sheet so that I can use it when I copy the sheet and create a new workbook.
see my other link regarding macros creating macros -
http://www.mrexcel.com/forum/showthread.php?t=380307