Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have lost my way on trying to create this macro, can anyone help please.
Many thanks for any help 1) I have variable number of sheets between two sheets called "" & "<", I would like the first part of the macro to delete all sheets (if any) between these two sheets. 2) I have a range of numbers (that can be repeated), I would like the macro to run through the range and add a "TEMPLATE" sheet in between the two sheets "" & "<" and rename the new sheet equal to the current number in the range, but only if it does not already exist. 3) I would like the sheets in between the two sheets "" & "<" to be shown in accending order PS. I already have about 60 sheets in the workbook and the above macro could up to another 40+, is there a limit to the number of sheets a macro can add? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i arrange alphabetically my sheets? | Excel Worksheet Functions | |||
Macro to delete unwanted sheets | Excel Discussion (Misc queries) | |||
Grouped Sheets - Windows Arrange | Excel Discussion (Misc queries) | |||
arrange sheets in alphatical order | New Users to Excel | |||
How do I arrange sheets in alphabetical order? | Excel Discussion (Misc queries) |