By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

AutoSort

c:\Laptop_backup\Flash Drive grey\Kravatz Inc\EB\CD\AutosortExample.xls

Problem

You want a list to remain sorted when you add a new item.

Record Sorting on column A

import Findlastrow and col

Events on a worksheet_change

Target object

EnableEvents - a little advanced