Determine last entry in colum

  • 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. 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
 
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.
 
Back
Top