Macro to print range without blank rows

[bgill]

Searched for this but can't find what I need (or can understand). I have a work book that I will be giving to others to use. I want to give them a macro that will automatically print a range in sheet. The number of rows of data they have will vary and I want to have the macro set up so it will not print the blank rows at the end of the range.

I have data in columns A:L and from Row 1 up to row 300.

I have a print macro already but can't figure out how to not print the blank rows.

Thank you!!

Becky

 

[VoG]

Maybe in your macro

With ActiveSheet
.PageSetup.PrintArea=.UsedRange.Address
End With

 

[bgill]

Thank you. It did work.

This is what I am using to print the whole page.

Application.Goto Reference:="Print2Aw"
Selection.PrintOut Copies:=1, Collate:=True

The range "Print2Aw" is the worksheet from A1:L300. Perhaps using the named range is not the way to go?