I've been working on a DDE that will work like a stock ticker and am running into a roadblock. I need the columns to sort continuously as the values within them are updated, but can't figure out how? For example:

Symbol - Yesterday's Close - Last Price - Net Change
F - 13.00 - 13.15 - 0.15
MSFT - 25.00 - 25.25 - 0.25
GE - 16.00 - 16.12 - 0.12

Yesterday's Close and Last Price would update through the DDE interface, and Net Change would be calculated as the difference. I need excel to automatically sort in descending order as the values change, thus making MSFT first on the list. Is this possible?? Any help would be much appreciated.

Hi

You can try using the sort routine in Worksheet_Change event of that particular sheet.

This event will get fired whenever there is change in your values

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)