Printing from macro

[elgringo56]

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]

Try the following:

PageSetup.PrintArea = ActiveSheet.UsedRange.Address