Using content of cell within a Macro

Hi. I am attempting to use a cell reference generated using the "address" function and text function (so the cell displays text only, not formula) as a means of defining the top left cell into which I want to paste a column of formulas. The reference cell is static, but the contents is dynamic. Is this possible? Would be very grateful for any advice. Thanks