Array Function help
I want three sheets to autofit certain columns. Here is the code that I
currently have in my script... ugly.
Worksheets("Sheet1").Columns("A:Z").AutoFit
Worksheets("Sheet2").Columns("A:Z").AutoFit
Worksheets("Sheet3").Columns("A:Z").AutoFit
I want to try something more like:
Worksheets(Array("Sheet1","Sheet2","sheet3")).Colu mns("A:Z").AutoFit
I'm getting an error on this code, though. Thanks in advance for
helping a beginner.
|