ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Does worksheet exist (https://www.excelbanter.com/excel-discussion-misc-queries/218408-does-worksheet-exist.html)

BB Ivan

Does worksheet exist
 
I'd like to check within a macro whether a specific worksheet exists within
the active workbook. If it doesn't, then I want to create it. What's the
easiest way?
Thanks!!

Frederik[_3_]

Does worksheet exist
 
Have a look at

http://spreadsheetpage.com/index.php...vba_functions/

Success!
--
met vriendelijke groetjes

"BB Ivan" schreef in bericht
...
I'd like to check within a macro whether a specific worksheet exists
within
the active workbook. If it doesn't, then I want to create it. What's the
easiest way?
Thanks!!





All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com