Save a select cell as a global variable in a worksheet
Posted on 2011-03-11
I have a spreadsheet with several columns.
In column B..(but not row 1)
When I type a value into
MFRNUM....etc.. OTHER COLUMNS HEADERS
ROW 2 -> 33343
ROW 3 -> 4412
ROW 4 -> 32324
ROW 5 -> 555
The current code
processes some code on worksheet change event...
and then in a module I use this code...to select the active cell
So by using the code above : example
If I go back and want to change ("B3")
and the code above executes
the cell selected will be ("B5")
I need it to go back to ("B3")
Is this possible?