PDA

View Full Version : Check for new highs in dynamic updating cells



username1
08-24-2011, 11:10 PM
Hey guys,

Pretty simple thing that is kind of hard to Google correctly. Just wondering how to check a cell that is always updating for new highs and lows, and I just want to update a static cell if we reach a new high or low in the number.

Bob Phillips
08-25-2011, 12:56 AM
Look up Worksheet_Change event, and just apply the high value to an adjacent cell.

username1
08-25-2011, 01:02 AM
Hey,


Sorry forgot to mention I was using an RTD function. It seems like VBA doesn't pick up on the changes when using this, am I right on this thought? Whenever I've looked around most things say it won't work with RTD

Bob Phillips
08-25-2011, 01:12 AM
Try linking a cell to the updated cell, just a simple =cell, and use the Worksheet_Calculate event.

username1
08-25-2011, 01:14 AM
Try linking a cell to the updated cell, just a simple =cell, and use the Worksheet_Calculate event.

Just comes up as ###### on the =cell

Bob Phillips
08-25-2011, 01:29 AM
Did you change cell to the actual cell reference?

username1
08-25-2011, 01:30 AM
Did you change cell to the actual cell reference?

Heh yea not that big of a beginner. If I left it as =cell it would just be #NAME?

But apparently trying to reference a RTD cell just gives you #####, quite weird

Bob Phillips
08-25-2011, 01:40 AM
That is odd. Can't say I am familiar with RTD in Excel, but a quick check on MSDN suggests they might trigger a recalculate on their own, so maybe just add some Worksheet_Calculate code to try it without bothering about the linked cell.