I have a solution for checking if an Excel worksheet exists or not. This can come in handy if you are creating a new sheet based on a dataset. You check for the new sheet and if the sheet exists you can alter the old sheet if the sheet does not exist then you can create a new sheet.
If Not Evaluate("ISREF('" & [A1] & "'!A1)") Then
Where Excel cell [A1] contains the name of the sheet you are checking for.
Now if this procedure was part of a loop you may wish to check all of the cells from say A1 to the last used row in column A. Then the following might be more relevant.Read More
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019
Excel Dashboard by City May 16, 2019
Excel Timesheet Example May 9, 2019
When TRIM Doesn't Work in Excel May 8, 2019
Excel Now Has 3D Pictures May 1, 2019
Using Index as a Dynamic Range April 30, 2019
Advanced Excel Skills April 28, 2019