Saving an address to be used in next open file

[SeniorTom]

I have a file that I compare instances by clicking on a cell to start the calculations(Worksheet_BeforeDoubleClick). I call this cell "ActivatedCell" and put the results in the next 3 columns using offset (x,y) then save the results. What I want to do is, the next time I open the file, clear the 3 columns. Is there a way to save the "ActivatedCell" so that it is available on the next open file?

Regards,
Tom

[CK76]

You'd need to store value external to .bas (code module).

Simplest method is to store it in an out of way cell.

Another is to write to external text file (or some other file) and read from it.

One other option, though I don't like the approach is to store it in registry.

Personally, I'd just store it in xlveryhidden worksheet.

[SeniorTom]

CK76, Thanks I'll try the hidden worksheet.