Code not hiding columns

  • Thread starter Thread starter Eva Shanley
  • Start date Start date
E

Eva Shanley

I recorded the following code that should hide Col. F in
Sheets 1, 2, and 3. This works fine when I record, but
when I run the code manually Col. F hides on Sheet 1 only,
while the column is merely selected on Sheets 2 & 3. Any
idea what happens here? Thanks in advance!

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Columns("F:F").Select
Selection.EntireColumn.Hidden = True
Sheets("Sheet1").Select
End Sub
 
try
Sub hidecolf()
For Each ws In Sheets(Array("Sheet1", "Sheet2", "Sheet3"))
ws.Columns("F:F").EntireColumn.Hidden = True
Next ws
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Never ending ARRAY code problems 18
How can I unhide columns on multiple worksheets in same workbook? 3
Hiding specific column on all worksheets 2
Array code only works on selected sheet 14
Print Macro code help 1
Macro to match 2 column values in different sheets 1
Excel VBA help: Text file formatting 19
Hide Cols ?? 3

Back
Top