Auto Selection of Print Area

ammdumas · Mar 15th, 2002, 01:07 PM

Have a spreadsheet which contains functions in 300 hundred rows.
Data is automatically imported using a macros.
Not all 300 rows are used most of the time for each import.
How do I set the Page Setup - Select Print Area to automatically select only the rows where data was imported?

[ This Message was edited by: ammdumas on 2002-03-15 12:08 ]

Al Chara · Mar 15th, 2002, 01:14 PM

Try this:
ActiveSheet.PageSetup.PrintArea=ActiveCell.CurrentRegion.Address

Hope this helps.
Kind regards, Al.

ammdumas · Mar 15th, 2002, 01:38 PM

Thanks. Tried it but it still prints everything. I think it still sees the formulas in the unused cells. I think that's the problem.

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

Mar 15th, 2002, 01:07 PM	#1
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	Have a spreadsheet which contains functions in 300 hundred rows. Data is automatically imported using a macros. Not all 300 rows are used most of the time for each import. How do I set the Page Setup - Select Print Area to automatically select only the rows where data was imported? [ This Message was edited by: ammdumas on 2002-03-15 12:08 ]

Mar 15th, 2002, 01:14 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try this: ActiveSheet.PageSetup.PrintArea=ActiveCell.CurrentRegion.Address Hope this helps. Kind regards, Al.

Mar 15th, 2002, 01:38 PM	#3
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	Thanks. Tried it but it still prints everything. I think it still sees the formulas in the unused cells. I think that's the problem.