printiing range
 

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

printiing range
 

Try this Roger

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Roger March" wrote in message news:6RmOb.148898$JQ1.42673@pd7tw1no...
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