Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Define list of worksheets
I have an excel file with a dozen worksheets. I can run my Delete_Columns
function on all of the worksheets with this command: Dim wks As Object For Each wks In Worksheets wks.Activate Delete_Columns Next wks My problem is that I want to run this function on all the worksheets except one ("History"). Is there a way to either exclude one worksheet or to define the list of worksheets (IR_5, IR_6, IR_6_1, IR_7, IR_8, IR_9, IR_10, IR_11, IR_any, IR_TBD, Doc_Only)? Thank you for any help you can give me, Judy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
Linking Drop-down list to worksheets | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
list values equal in 2 worksheets? | Excel Worksheet Functions | |||
List of Worksheets in a work book | Excel Worksheet Functions |