How to code to insert / delete any worksheet?

E

Eric

Under column A, there is a list of numbers, such as
1,4,9, ...
If there is no existing worksheet named "1", then insert a new worksheet
named under "1", else do nothing.

If 3 is not included under column A and there is an existing worksheet named
under "3", then delete it.

Does anyone have any suggestions on how to code it in excel?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to program excel to insert / delete any worksheet? 1
How to program to insert / delete any worksheet? 1
How to do it in Macro - 30 Nov? 2
what excel function to use 2
Does anyone have any suggesitons on how to do it for worksheet? 1
Conditional Sum across WORKSHEET 6
delete worksheet 3
How do you insert & delete rows in a protected worksheet? 1

Top