I have written the macro below, which looks in cells on a sheet that is selected and then if there is a 0 in the cell, will then select a different sheet and print it.
The problem is that now the second sheet is selected, but I want to go back to the initially selected sheet and check the cells on that sheet. I have to do this within another macro so it would be easier if I could find a way to reselect the last selected sheet, rather than write a different macro for each sheet. Is there a way to do this?
This macro is part of another macro, so at this point, sheet X is selected
'(so, now the sheet "GT bypass valves thermal checks" is selected, but I want to reselect sheet X now and continue to check the cells in that sheet)
Bookmarks