Hello,
I need to move the active sheet after the Last Sheet I was on it.
The Last Sheet Name is already recorded in a range called LastSheet in my current workbook.
Here is how I wrote this code:
but this is not working.![]()
ActiveSheet.Move after:=Sheets(Chr(34) & Range("LastSheet")(1, 1).value & Chr(34))
What is wrong here?
Could you please advise?
Thanks
Bookmarks