How to code to insert / delete any worksheet?
 

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

How to code to insert / delete any worksheet?
 

See my response in other posting of same question in this forum. That link:
http://www.microsoft.com/office/comm...5-475f99c4d61a



"Eric" wrote:

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