Code to fill down formula

Hello.
I ran the code below but it did not execute at all and instead highlighted in yellow a part of the code (see red font). This is the workbook i'm working with Fill Down Formula.xlsm

Please Login or Register  to view this content.

Any ideas?
Thanks.

You need something like:

Please Login or Register  to view this content.

However, that's not right because, if you put that formula in column 2, it refers to column XFC, etc

Regards, TMS

Thanks for the reply. I still need help with the code.

I have a suggestion:
In reference to the section in the code which takes the second to last column in the 18th row, so for arguments sake we will call this cell G18, and multiply the retail by the cost (the cost being in cell A1 which happens to be 0.3) Is there a way to have the last row in this code to equal to the last cell (with data in it) in column A but at the same time still identify cell G18 as the cell in the 18th row on the 2nd to last column? Meaning, I don't want to refer to G18 as: Range(Cells(18, lc), Cells(lr - 1, lc)) but rather as: Range(Cells(18, lc)) since I strongly feel that Excel is getting confused which is the last row.

Just:

Please Login or Register  to view this content.

Regards, TMS

... not completing the way I want it to.

Describe what you DO want it to do. Tell us the worksheet formula(s) you want and which cells you want it/them in ... not the code, the actual formula(s) you want to end up with and the cells you want it/them to be in.

You misunderstand; "Cells" is something of a misnomer in this case:

Please Login or Register  to view this content.

... is a single cell in row 18, in the next to the last column, so not much point looping through it