Posted to microsoft.public.excel.programming

external usenet poster

Posts: 5

Setting up a variable print range

I am looking for an easy way to use a macro to select a
print range by determining the last row and column used.
However, the last row and column used will change between
users. For example, if the user only used up to row 98
and
column L is the last column used. I need to select the
range A1 to L98 and print this range. Thanks for any
input.

gary

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Using named range to extend print area for variable number of columns	Pierre	Excel Worksheet Functions	3	April 10th 08 05:51 PM
Setting print range using VBA	Dave Ramage[_2_]	Excel Programming	0	July 29th 03 04:35 PM
Setting print range using VBA	VBANut	Excel Programming	0	July 29th 03 04:20 PM
Setting print range using VBA	Ron de Bruin	Excel Programming	0	July 29th 03 03:59 PM
Setting Print range	Tom Ogilvy	Excel Programming	3	July 25th 03 04:06 AM

All times are GMT +1. The time now is 09:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us