j1981
asked on
Excel VBA code to check and add sheet
Hello experts,
I have an Excel workbook which has a single sheet named "Start"
I need a button here titled 'Run'. Clicking on it should run a macro code which will do the following:
If there already exists a sheet named "Scenario" in this workbook (which is not there when the macro first runs)
Clear all the contents of the "Scenario" sheet
else
Add a worksheet to the workbook with the name "Scenario"
End if
Thanks in advance!
I have an Excel workbook which has a single sheet named "Start"
I need a button here titled 'Run'. Clicking on it should run a macro code which will do the following:
If there already exists a sheet named "Scenario" in this workbook (which is not there when the macro first runs)
Clear all the contents of the "Scenario" sheet
else
Add a worksheet to the workbook with the name "Scenario"
End if
Thanks in advance!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have no problem you attribute points un-equally but pls let me know why as your post clearly stated:
Clear all the contents of the "Scenario" sheet.
You did not mention anything about hidden rows or any of the like.
gowflow
Clear all the contents of the "Scenario" sheet.
You did not mention anything about hidden rows or any of the like.
gowflow
ASKER
Hi gowflow,
This question was to resolve one portion I didnt know from an existing code that I have. I didnt want to post the whole code here which is the reason why I raised a hypothetical question and I intended to copy paste the code from the solutions to my existing code to make it work.
Looking at both solutions, I felt that having the check as a function - as written by redmondb - was more readable and intuitive, rather than iterating through all of the worksheets(which works very well as well).
So I chose redmondb's code for my purpose and awarded him higher points, because it helped me to solve my bigger problem more easily.
But I want to thank you for your very quick response as well. Please let me know if that didnt explain.
j1981
This question was to resolve one portion I didnt know from an existing code that I have. I didnt want to post the whole code here which is the reason why I raised a hypothetical question and I intended to copy paste the code from the solutions to my existing code to make it work.
Looking at both solutions, I felt that having the check as a function - as written by redmondb - was more readable and intuitive, rather than iterating through all of the worksheets(which works very well as well).
So I chose redmondb's code for my purpose and awarded him higher points, because it helped me to solve my bigger problem more easily.
But I want to thank you for your very quick response as well. Please let me know if that didnt explain.
j1981
Thanks, j1981.
no problem and your welcomed. For sure you can award point like you feel and for me the most important is to know that the solution worked for you. Your rightfully free to choose any code that you feel best integrate with your project and I thank you for your detailed explanation and rest assured my concern is to know that my solution works I knew it did as I test each and every solution I post prior to submitting.
Rgds/gowflow
Rgds/gowflow
ASKER
Yes. I had tested it too and it worked perfectly. Once again, I really appreciate your response.
Thanks,
j1981
Thanks,
j1981
No problem pls feel free to ask for help any time. Sorry for these comments if they were un-appropriate.
gowflow
gowflow
ASKER
They were not. Given the effort you put into helping out someone, I think it was only fair you asked.
j1981
j1981
I will keep this question monitored so if in the future you need any help pls post a link to the question you need assistance and I will be glad to look at it (for sure if no one else speed me up !!!) :)
gowflow
gowflow
ASKER
:) I appreciate it.
j1981
j1981
welcome
gowflow
gowflow
ASKER