Thread
:
adding worksheet with macro but need to get back to 1st sheet
View Single Post
#
5
Posted to microsoft.public.excel.programming
Gord Dibben
external usenet poster
Posts: 22,906
adding worksheet with macro but need to get back to 1st sheet
Sub return_to()
Dim oldsheet As Worksheet
Set oldsheet = ActiveSheet
ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
oldsheet.Select
End Sub
Gord Dibben MS Excel MVP
On Thu, 13 Dec 2007 13:29:48 -0800 (PST),
wrote:
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.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben