write a formula for every cell in a column for the total number of rows of data

[excelaspire0219]

Below is my code -
The part of the codein blue font is for writting formulas in the cells. The current code is writing formula for every cell in the column until the last cell. I want to write the formula for only the number of rows that actually contain the data.

Can anyone help me please??

Thanks.

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.

[excelaspire0219]

Thanks. But when I tried to run the macro it gave me a compile error - invalid or unqualified reference and highighted the .Cells part of the code. Any idea why that happened??