Print Refedit range?

[T.c.Goosen1977]

I have a Refedit range box in one of my yserforms and under it a
commandbutton...when i select a range making use of the Refedit box it
works fine but the moment i click the commandbutton it does not print
the selected range..it prints a blank page...i need some advice on the
coding to print the selected range

Thanks
Theuns

 

[Leith Ross]

Hello,

Seet the print area to the RefEdit range before printing out the
worksheet.

With Worksheets("Sheet1")
..PageSetup.PrintArea = "$A$1:$C$5"
..PrintOut
..PageSetup.PrintArea = ""
End With

Change Sheet1 to match the name of the Worksheet the range is part of.

Sincerely,
Leith Ross

 

[T.c.Goosen1977]

yes, that is part of my problem: setting the printing range to the
selected refedit range....the refedit is on a userform and it works
fine when i select the range...but when i click the printing
commandbutton i...it prints blank...so how do i assign the refedit
range to the printing command button?

 

[T.c.Goosen1977]

Got it right...thanks guys



With Range(RefEdit1)
..PrintOut Copies:=1, Collate:=True
End With