Getting a macro to use text in a worksheet

I have text being created in a cell by a formula, which forms a cell address.
I then want to use that cell address created in the worksheet, in a macro.
The macro code will use whatever cell address is created by that text.
The text created by the cell address will change, depending on the outcome of the formula.
What is the code necessary in the macro to pick up the text from the worksheet - Is that even possible?
My Excel knowledge is high, but my VBA knowledge is limited.