View Single Post
  #5   Report Post  
Judy Ward
 
Posts: n/a
Default

Thank you all very much for your quick responses. This is exactly what I
needed.

"Judy Ward" wrote:

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