VBA - Can I select a new active cell based on the value of the current active cell?

Total noob here, please be gentle.

Is it possible to set a new active cell from the value of the current active cell? I am kicking myself because I am certain I have done this before, but have been researching for hours with no luck.

The active cell is "G22". The cell address in this cell is a concatenated value dependent on the values of two text boxes on a user form. In this case the concatenated resultant is “P49”.

Stumped and feeling foolish. Any help appreciated.

Hi

Range() will take a string, so if cell G22 contains a string representation of a cell address, you can activate it via:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

OUTSTANDING! Worked Like a charm. Firefly, you have my eternal gratitude!