How to refer to a named range that is hard coded in a cell via VBA

[Loun]

Hi All,

Can anybody please help me? What should be a simple task has become one of major frustration!

Basically, I have a list of named ranges hard coded into cells.

I have a loop that then cycles through these named ranges.

What I want to do is when it gets to a certain one, let's say "TEST_123" , I want it to select that range.

So, if I was doing it manually I would simply use Range("TEST_123").Select

I suppose I'm looking for the equivalent of the INDIRECT function, that would be =INDIRECT(A1), with A1 being the active cell of the loop that contains the hard coded named range.

Thanks in Advance!
Lou

 

[Loun]

Managed to figure it out.....Solution below incase anyone comes across the same issue as me in the future!

Application.Goto reference:= NamedRange

With NamedRange being your variable that refers to the indirect cell

Something so simple but yet so difficult to figure out!