Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dennis- Thanks for your response. I wrote code similar to yours- the
process of changing each sheet individually takes 80+/- seconds in this workbook, which I'm trying to shorten with the Group All idea. Gord- I'm trying to allow users the ability to change paper size from Letter to A4. Is there any validity to the idea of creating a string (such as "Sheet1", "Sheet2", "Sheet3" etc) with the variable name TabNamesList to serve as an argument in this line: Sheets(Array(TabNamesList)).Select It generated an error on previous tries but I'm clutching at straws, now. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Syntax for using "IF"... | Excel Discussion (Misc queries) | |||
Insert more than 1 Row Syntax | Excel Worksheet Functions | |||
Rate syntax | Excel Discussion (Misc queries) | |||
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |