VBA Check for New Workbook

[ebrehm]

I need help Please!!!

I currently have code that runs through several actions for each variable "Num" - 1 - 20. My current Coding states something like,
If Num = 1 then Add new workbook and continue to add only "Sheets" for Num = 2 - 20. HOWEVER>.... It has come to my attention that not all of the users start with NUM = 1. Some users skip the first line (Num = 1) and start with Num = 2 or 3, etc.

So my problem now is, if a user skips num = 1 and starts with num = 2, the code will never Add a New "Workbook". Therefore, if no New Workbook is ever added no New Sheets can be added to the workbook.

How can I code so that a New Workbook is added on the first line item whether it be num = 1 or 2 or 3, 4,... etc through 20. Some kind of a check for the first line item????

By the way - I have a variable name for the new workbook that num = 1 is supposed to create: "newsheetname". But how do I check the status of that variable if it hasn't been created yet???

Thanks - Erica

 

[ebrehm]

Duh...
I guess it just took me putting it all out on "paper" to figure out that I can do a "IsEmpty" check for the variable first then proceed to insert new Workbook if needed.

Thanks