| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array function - I think! | Excel Worksheet Functions | |||
| OR function in array-entered IF function | Excel Worksheet Functions | |||
| Array Function | Excel Worksheet Functions | |||
| #DIV/0! in the array function | Excel Worksheet Functions | |||
| UDF Array function | Excel Programming | |||
Threaded Mode
