Select a cell based on the value of another cell

[JeremyA1976]

I have a cell range reference (ex. D4) entered into cell AC1 as a string. In VBA, how do you write the code to select cell D4, based only on what the value is at AC1? Keep in mind, cell value of AC1 will be different every calculation. I thought you can use indirect in this case, but I am not sure how the code is supposed to look. Both cells are on the same worksheet "Sheet1".

 

[Fluff]

Like

   Range(Range("AC1").Value).Select

 

[JeremyA1976]

PERFECT! Thanks Fluff.

 

[Fluff]

Glad to help & thanks for the feedback