Home / Tag Archives: exists

Tag Archives: exists

How to check a Workbook Exists

This macro will provide a quick and easy way to check that a Workbook exists before you attempt to access it. This can be a problem when trying to open a Workbook from within another Workbook, or a Workbook that is required has been deleted or moved. If you try to access a Workbook that does not exist your macro will fail with the following debug message

Read More »

How to check a Worksheet Exists

The following simple macro will provide a quick and easy way to make sure a Worksheet exists in a Workbook before you start any changes or other processing on that worksheet. This can be a problem when working with large numbers of worksheets that are created during a macro process. If you try to create a worksheet name that already exists your macro will fail with the following debug message

Read More »

Chart Exists Function

The following Function has been designed to check if a chart already exists in the open workbook. If it does exist then it will return TRUE, if not then the Function will return FALSE. Based on this function your other code can then create the chart if needed or use the existing chart.

Read More »