I'm trying to collect data on hourly highs and lows. I have been using a circular reference to get the H/Ls. ie In cell c3, =max("live price",c3) I'm trying to use a macro to reset the circular references. when I do it by hand, the formula just resets itself when I click in the cell. I tried recording a macro to click in the cell, but the cell didn't reset. Then I tried cutting and pasting the formula to a different cell and then cutting and pasting it back. I got an error. First time the macro recorder ever returned an error on what it had written. Any ideas?