Macro to print specific range

Q45 · Feb 20th, 2002, 06:19 AM

How do I write a macro for a button that will print multiple specific ranges in a workbook? (i.e., I have sheets for January, February, March, etc... but I only want a specific range from each page printed (A1:F13).)

And I do I keep the format the same so that it will print the same way on different computers?

Thanks!

Tikas A. Planck · Feb 20th, 2002, 06:34 AM

You should be able to create a macro to do this with the macro recorder.

Q45 · Feb 20th, 2002, 06:38 AM

How does that work?

Tikas A. Planck · Feb 20th, 2002, 07:48 AM

Have a look at "Record a macro" in the Help index.

Mark W. · Feb 20th, 2002, 08:11 AM

Why a macro? Why not define the Print_Area once on each worksheet using Defined Names or the File | Print Area | Set Print Area menu command?

[ This Message was edited by: Mark W. on 2002-02-20 07:11 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 06:19 AM	#1
Q45 New Member Join Date: Feb 2002 Posts: 32	How do I write a macro for a button that will print multiple specific ranges in a workbook? (i.e., I have sheets for January, February, March, etc... but I only want a specific range from each page printed (A1:F13).) And I do I keep the format the same so that it will print the same way on different computers? Thanks!

Feb 20th, 2002, 06:34 AM	#2
Tikas A. Planck Join Date: Feb 2002 Posts: 47	You should be able to create a macro to do this with the macro recorder.

Feb 20th, 2002, 06:38 AM	#3
Q45 New Member Join Date: Feb 2002 Posts: 32	How does that work?

Feb 20th, 2002, 07:48 AM	#4
Tikas A. Planck Join Date: Feb 2002 Posts: 47	Have a look at "Record a macro" in the Help index.

Feb 20th, 2002, 08:11 AM	#5
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Why a macro? Why not define the Print_Area once on each worksheet using Defined Names or the File \| Print Area \| Set Print Area menu command? [ This Message was edited by: Mark W. on 2002-02-20 07:11 ]