Problem reading formula with ActiveCell.Formula

Hello! My Problem is that I don't know how to capture formula and than insert variable in it.
My code: red is what does not work

Please Login or Register  to view this content.

I want to capture the red formula in active cell and than paste just the formulas adress R[x]Cx to formulas below. The formulas below I would write them myself, I just want the first formula R[x]Cx copied below.

I hope this is posible and that someone will know to help me.

Hello,

I've added code tags to your code to make it easier to read. Unfortunately, the code tags don't show the red colour in the default forum skin.

Anyone who wants to chip in, please change to the Child skin, so you can see the red colored lines.

cheers

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here