printiing range

  • Thread starter Thread starter Roger March
  • Start date Start date
R

Roger March

I need help in creating a macro to find the last entry in a colum after I
have sorted a range. (range changes every time) What i have is a order
entry sheet , I have a macro to
sort the range by the entry column, now I need to find the last entry and
print from last entry to A1. A macro attach'd to a button would be the cats
ass.
help Please

tks

Roger
 
Try this Roger

Sub printtest()
Endrow = Cells(Rows.Count, "A").End(xlUp).Row
Range("a1:a" & Endrow).PrintOut
End Sub
 
Back
Top