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
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