I am trying to get back to a worksheet
My code goes along the lines of
but falls at the ActiveSheet = Worksheets(ThisWeekSheet) bit
how can i make this the active sheet again?
Martin
My code goes along the lines of
Code:
Dim ThisWeekSheet As String
ThisWeekSheet = ActiveSheet.Name
Sheets("DATA_FEED").Select
Call another_function
'goback to original worksheet
ActiveSheet = Worksheets(ThisWeekSheet)
how can i make this the active sheet again?
Martin