|
|
#13
10-04-2010, 05:19 PM
|
|||
|
|||
Okay guys, I think I've figured out the problem. The macro is working fine, but the reason it wasn't sorting the new additions (and still isn't) is because it only sets the range to whatever it was when I record the macro. As soon as I add in new orders, the range changes and the macro doesn't sort them all.
Pic attached is what I mean. If I set the macro while I've got Example 1 to 15, then add in 16 later, it'll only sort 1 to 15 upon opening. Any ideas, guys? 
|
| Tags |
| macro, sort |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sorting question
|
markg2 | Excel | 4 | 01-25-2010 03:13 PM |
| automatic start of macro + help on writing helper function | vsempoux | Word | 3 | 10-09-2009 03:01 AM |
| Sorting Outlook TO: field | anakeimai | Outlook | 0 | 09-30-2009 06:15 AM |
| Sorting Tasks by Contacts | Bat | Outlook | 0 | 09-24-2007 01:20 PM |
| sheet linking, sorting | nickbfe | Excel | 0 | 05-19-2006 11:00 AM |
Windows XP 
Office 2003
Threaded Mode