Formatting Macro

[e_loveall]

I recorded a formatting macro for a report that we use all the time. We import data from an AS400 system, and then my report formats the raw data into "pretty" report.

My number of columns will always be the same, but the number of rows won't. Is there a way to set the print area with the fixed number of columns but leave the row number undefined since it will be different every time?

Thanks!

 

[lenze]

How about a simple print macro?

Sub PrintIt()
Range("$A$1").Select
Selection.CurrentRegion.Select
Selection.PrintOut Copies:=1, Collate:=True
End Sub

 

[e_loveall]

I see what the code is doing. I took out the print code because I don't need to actually print out the report (it gets emailed). However, when I tried to alter the page setup in the preview section, I get a message that says not enough memory, and my system blows up.

Basically, the report goes from A1:X(whatever row). Any other ideas on how to leave this undefined?