Will appreciate if someone could advise me on how to do this:
In an Excel workbook I have a few sheets. I'm trying to write a macro which looks for a named sheet and if it is there do the required action and if it is not there then do nothing or simply show a message saying the sheet is not present.
I have the codes which action on the sheet IF the sheet is in the workbook but if not then macro stops with message "Out of range" or something similar.
Please, could somebody advise me how I can achieve this.