Check for new highs in dynamic updating cells

[username1]

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]

Look up Worksheet_Change event, and just apply the high value to an adjacent cell.

[username1]

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]

Try linking a cell to the updated cell, just a simple =cell, and use the Worksheet_Calculate event.

[username1]

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]

Did you change cell to the actual cell reference?

[username1]

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]

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.