VBA insert formula referencing offset cells and anchor reference

Hi all,

I have a formula I am trying to insert into a range of cells below the active cell that references the left most column from the same row and the active cell. The complication comes when I try and add an anchor to that cell to apply it to a range.

An example might be, user selects active cell H3 and runs macro. Row A contains data from cell A4 to A50. In cells H4:H50 the formula that needs to be entered is

Formula:

Please Login or Register  to view this content.

Please note, the column and row number of the active cell may be different but the user will always reference column A of the same row.

I've come up with the below piece of code that works to put the formula in the correct cell directly below the active cell but without the anchor "$" against the column and row respectively.

Please Login or Register  to view this content.

Any help would be most appreciated, thanks in advance!

James

perhaps simply

Please Login or Register  to view this content.

no but it was missing a closing parenthesis which I have now added

you're welcome :-)

please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')