We help IT Professionals succeed at work.

activating a cell based on a stored value

Shanan212
Shanan212 asked
on
Medium Priority
269 Views
Last Modified: 2012-05-12
Hi,

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
        ActiveCell.Activate

Above is giving me error :/ 'Assignment to constant not permitted'

Any help is appreciated!

Thanks
Comment
Watch Question

Rob HensonFinance Analyst
CERTIFIED EXPERT
Commented:
Try:

Range(Cells(1,14).Value).Select

Thanks
Rob H
Excel VBA Developer
CERTIFIED EXPERT
Top Expert 2014
Commented:
To activate the cell specified by the value in Cells(1,14):
Range(Cells(1, 14).Value).Activate

Author

Commented:
Thanks all!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.