Hi all .... seasons greetings and a happy new year.
Hope you can help.
Lets say cell A1 contains a number. The number changes throughout the day as a result from an automatic DLL refresh.
I'd like cell A2 to tell me the maximum number in cell A1 during the period that the workbook is open, and A3 to tell me the minimum.
I've tried this in A2, "if(A1>A2,A1,A2)", but as I expected, I got the dreaded circular reference error message.
I guess I need a VB solution.
Regards ..... G-fer.
Hope you can help.
Lets say cell A1 contains a number. The number changes throughout the day as a result from an automatic DLL refresh.
I'd like cell A2 to tell me the maximum number in cell A1 during the period that the workbook is open, and A3 to tell me the minimum.
I've tried this in A2, "if(A1>A2,A1,A2)", but as I expected, I got the dreaded circular reference error message.
I guess I need a VB solution.
Regards ..... G-fer.