Using VBA I am trying to find and store the location of a cell containing a certain value (for the sake of example let's say 1).

I need to be able to update this value by calling on it's function and the value must be global so it can be used in multiple Subs.

I have to say I am just lost with this one. Any suggestions?