Andy Pilkington
Board Regular
- Joined
- Jan 23, 2014
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
Hi, I have a macro that moves a worksheet from the current workbook into a new workbook therefore the worksheet no longer exists in the current workbook. Of course when I try to execute the same macro again it goes into error because the sheet is no longer there.
Is there a way I can avoid this by, for example, including a "what-if" that bypasses the command or executes the next command in the macro?
Thanks in advance.
AP
Is there a way I can avoid this by, for example, including a "what-if" that bypasses the command or executes the next command in the macro?
Thanks in advance.
AP