printiing range

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
 
R

Ron de Bruin

Try this Roger

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Remove Identical words 0
Check a range to see if a value exists in it 5
Eliminate blank row at top of Text Box entries 3
Check a 'Logsheet' for a match, before continuing a sub 4
Problem sorting a range of columns using VBA 1
Determine last entry in colum 1
Delete contents of cells in a range based on value of a cell 2

Top