Hi,

I'm working on a macro but got stock with this. I need the code to add a column to the right of the active cell (which I achieved), then I need to add a formula on the cell to the right of the Active Cell, and below, for as many rows as column A has content (this is the part I need help with.

My current (broken) code is as follows:



HTML Code: 
What do I have to change to achieve this?

Thanks for your help