Hi,
I am currently using a macro which selects the previous sheet.
ActiveSheet.Previous.Select
The problem is that when there is no sheet prior to a sheet, an error is shown on the screen.
Can you suggest a code which would ask the macro to go to the previous sheet (if any) and not to show an error if there is no previous sheet?
I am currently using a macro which selects the previous sheet.
ActiveSheet.Previous.Select
The problem is that when there is no sheet prior to a sheet, an error is shown on the screen.
Can you suggest a code which would ask the macro to go to the previous sheet (if any) and not to show an error if there is no previous sheet?