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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 271 - 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