If cell in same row column A contains anything, past formula in column H same row

[kldailey]

If column A cell 1 has anything in it, I want to past this formula

Please Login or Register  to view this content.

in column H on the same row.
I want it to simply look down Column A doing the same thing until blank cell found.
Of course the formula would need to have the row number changed each time or have simply look in the same row.

[davesexcel]

Please Login or Register  to view this content.

When you have the correct formula in a cell, use your macro recorder, click on the cell then hit F2 to edit it. Then hit enter, this is what your formula will be in VBA.