You can use (hidden) cells as variables. E.g., you could hide Column C, set C1 to
and use it as
Alternatively you can write VBA Macros which set and read a global variable.
Edit: AKX renders my Answer partially incorrect. I had no idea you could name cells in Excel.