I have three lines of code that do the following:
(1) Opens another file based on a filepath in a cell in the current workbook.
(2) Copies the values of a named range in the newly opened book.
(3) Pastes values in tab "Detail" of the original workbook.
When I put the three lines in the...
I am trying to get back to a worksheet
My code goes along the lines of
Dim ThisWeekSheet As String
ThisWeekSheet = ActiveSheet.Name
'goback to original worksheet
ActiveSheet = Worksheets(ThisWeekSheet)
but falls at the ActiveSheet =...