|
Posted to microsoft.public.excel.misc
|
|
|
sort macro
Thank you Don. It works!
"Don Guillett" wrote:
The best way is to set up a self adjusting named range
On the sheet desiredInsertnamedefinename it SortRangein the formula box
=offset($a$1,0,0,counta($a:$a),12)
Look in the help index for OFFSET for more info
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Jean-Marie" wrote in message
...
Hello,
I would like to write a macro to sort data from a list which is getting
longer and longer. How to tell the macro to go to the last non empty cell?
Thanks in advance,
.
|