Forum Discussion
Automatically sort data HELP!
Hey guys Question 1: How do I automatically (without out pressing the sort button) sort data in ascending order? Question 2: Alot of my values will be 0, and therefore if I sort in ascendi...
Thanks Rich,
Where can I find the VBA code in that excel spreadsheet you sent?
When I open VIEW CODE, there doesn't seem to be anything in there?
Thanks
Matt
Matt,
The code is in two places, Sheet 1, Private Sub Worksheet_Change and Module 1, Sub Mymacro. see image attached which shows the code and project structure.
Rich
