Print Macro when not sure what cells to print out

[Jewelfine]

I have created a macro to format data that gets dumped into excel. Each time it is dumped I don't know how many rows of data there are.

Once the formatting is done I would like it to set the spreadsheet to print only the data that was dumped with the formatting the macro did.

ie Today I want it to print A1 to O25
Tomorrow Print A1 to O300

Is there a way to do this?
Thanx in advance

 

[VoG]

Re: Print Macro when not sure what cells to print

Try

Sub test()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
ActiveSheet.PageSetup.PrintArea = "A1:O" & LR
ActiveSheet.PrintOut
End Sub

 

[Jewelfine]

Re: Print Macro when not sure what cells to print

THanx for the reply
All I seem to get is the title on the page