LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default What's the VBA syntax to replicate this?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax for using "IF"... garry05 Excel Discussion (Misc queries) 4 December 7th 05 10:15 PM
Insert more than 1 Row Syntax blazzae Excel Worksheet Functions 5 July 10th 05 12:46 AM
Rate syntax KWIGZ Excel Discussion (Misc queries) 2 June 16th 05 07:59 PM
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS KENITOSAN Excel Discussion (Misc queries) 4 February 19th 05 10:06 PM
Previous Post - Correct Syntax Query Clarence Crow Excel Worksheet Functions 0 December 7th 04 05:35 AM


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"