LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default set print area for variable number of columns

Excel 2002
Hi I want to create a macro to set the print area on a worksheet where the
number of columns will vary. I've tried adapting the advice on setting for
variable rows but get run errors, usually 424. My knowledge of VBA is not
good so please could you keep it simple for me.
Many 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
Variable print area via a macro Andrew Excel Discussion (Misc queries) 9 September 16th 08 09:01 AM
Using named range to extend print area for variable number of columns Pierre Excel Worksheet Functions 3 April 10th 08 05:51 PM
Set print area on variable range Tom Excel Programming 4 March 28th 07 03:52 PM
variable print area? Jim Cone Excel Programming 0 March 30th 06 11:54 PM
Variable print area BOBF Excel Discussion (Misc queries) 2 March 22nd 05 01:47 PM


All times are GMT +1. The time now is 08:06 AM.

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"