Recording a high value from another cell

Not possible?

You'll need a little bit of macro code in the sheet change event for the sheet that gets updated...

Please Login or Register  to view this content.

Hi Andrew

Many thanks for your reply.

I should have mentioned that I am a certified dummy with these types of problems.

However, from reading other threads here I left clicked on the worksheet and pasted in the above code.

Nothing appears to happen though in cell AF5.

No doubt I need the step by step dummies guide to achieve a result.

Cell A1 by the way has other info in it from the program I use if that in any way helps.

Thanks again

Hammer

You can use any cell you like to record the high value, just change the sTARGET_RANGE cell to whichever cell you want to use, so if say you wanted the high value recorded in C5 you'd change the 3rd line of code to:

Please Login or Register  to view this content.

OK, to make it work:

1. Go into the VB Editor (Alt-F11)
2. In the left-hand pane double click on the sheet which is going to be updated.
3. From the left-hand drop-down list above the text editor select "Worksheet"
4. From the right-hand drop down select "Change"
5. Excel will put in the first and last lines of my code automatically, so you'll have a screen which looks like:

Please Login or Register  to view this content.

6. Paste in the code I gave you above - you won't need to paste the first and last lines, because they're already there.

7. That should be it.

Let me know if it works for you.

Andrew, pure genius!!!
Thank you so much for your time and effort, not to mention patience

What a great site this is.