Printing from macro

elgringo56 · Apr 16th, 2002, 08:53 PM

I used a macro to filter data from a list. That data is now positioned on a form that I would like to print. My problem is that I have no idea how much data is there, but I want to print it all, and no more. how do I under macro control, select only that data so that I can print selection?

Al Chara · Apr 17th, 2002, 10:54 AM

Try the following:

PageSetup.PrintArea = ActiveSheet.UsedRange.Address

Apr 17th, 2002, 10:54 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: PageSetup.PrintArea = ActiveSheet.UsedRange.Address __________________ Kind regards, Al Chara

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

Apr 16th, 2002, 08:53 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	I used a macro to filter data from a list. That data is now positioned on a form that I would like to print. My problem is that I have no idea how much data is there, but I want to print it all, and no more. how do I under macro control, select only that data so that I can print selection?