CODEWITHSUNDEEP
excelvba
GeorgeInNC
GeorgeInNC

Reputation: 35

Use a cell address that's the string content of another cell in an Excel 2013 VBA Range command

In cell A1, there is the string content of "B3", which is the address of another cell. The content of cell A1 changes based upon other user actions. I want to get the content of A1 to be used in an Excel 2013 VBA macro Range(?).Activate command to make cell B3 the active cell. I've searched, Googled, tried various approaches -- all to no success. Any help is greatly appreciated.

Upvotes: 0

Views: 323

Answers (1)

BrakNicku
BrakNicku

Reputation: 5991

I think this is what you need (change the name of the sheet object):

Sheet1.Range(Sheet1.Range("a1").Value2).Activate

Or (if you want to use active sheet)

ActiveSheet.Range(ActiveSheet.Range("a1").Value2).Activate

Upvotes: 0

Related Questions