I have a formula which assigns its address to cell like below
Cells(1, 14).Value = ActiveCell.Address
Say the above stores ($N$2)
After the above, I have few formulas coming up.
At the end, I want to activate the cell which is stored in cell(1,14)...so activate cell N2 again
how do I reassign this?
ActiveCell.Address = Cells(1, 14).Value
Above is giving me error :/ 'Assignment to constant not permitted'
Any help is appreciated!