Determine last entry in colum

R

Roger March

I need help in creating a macro to find the last entry in a colum after I
have sorted a range. 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
 
J

Jonathan Rynd

I need help in creating a macro to find the last entry in a colum
after I have sorted a range. 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.
Click to expand...

Look into the End method of the Range object.
For more information, ask in the excel.programming group.
 

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
printiing range 1
how do I copy the last 20 entries in an expanding list 4
calculate last 4 data points in a column (with sometimes blank rows) 7
formula for displaying only the last entry of a group of cells 2
Duplicate entry in a column/row 14
Hide columns based on row values 2

Top