Hello and thanks in advance.
Quick question, I hope!
I have code that I want to check if a sheet exists, and if it exists a sub macro is run. But if there is no worksheet with that name then I want to continue the code.
I am having trouble with the part where if there is no worksheet to let the code run as it was running before this check.
Quick question, I hope!
I have code that I want to check if a sheet exists, and if it exists a sub macro is run. But if there is no worksheet with that name then I want to continue the code.
I am having trouble with the part where if there is no worksheet to let the code run as it was running before this check.
VBA Code:
Check to see if "CC Date" sheet exists; if yes then run Clean_Poes_Data
For Each ws In Worksheets
If ws.Name = "CC Date" Then Call Clean_POES_DATA
Next