Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to insert one worksheet into another | Excel Discussion (Misc queries) | |||
VBA code to delete rows | Excel Discussion (Misc queries) | |||
Unable to delete or insert a worksheet. | Excel Discussion (Misc queries) | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
code to delete rows | Excel Discussion (Misc queries) |