Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding worksheet with macro but need to get back to 1st sheet
I have a macro adding a worksheet to a workbook. I am using:
ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count) I then need to "get back" to the first sheet to make it active - problem is I cannot reference it by its name - the name on the first sheet will change each time I use this workbook. Any help would be greatly appreciated Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to go back to last used sheet | Excel Programming | |||
copy back macro/roll back | Excel Worksheet Functions | |||
Macro to prevent adding sheet in a workbook. | Excel Programming | |||
Adding new sheet problem-Macro | Excel Programming | |||
macro adding formula to new sheet | Excel Discussion (Misc queries) |