Over my head here? You betcha!

I have put together a macro that examines the colorIndex of a cell and
stores it in an integer variable called intial_cell_color. the macro
then changes the color index of that cell and exits. I need to be able
to restore the original colorIndex to that cell or another later on by
running another or the same macro. Clearly, the variable will lose its
lifetime when the first macro exits. Is there a way I can store
initial_cell_color somewhere and have it available when I run another
macro or the first one again.

I have tried using an object variable but can figure out how to store
the colorIndex in it.

Will someone please suggest a way to do what I want to do? That is
retrieve the colorIndex of a cell or range of cells, store it somewhere
so I can restore it later on?

Thank you.