1004 run-time error, Application or object-defined error

Hi

I'm trying to go through a range of cells in a worksheet and write a formula in each one. However I keep getting the error:

This is the current code

Please Login or Register  to view this content.

It keep fails at the line of

Please Login or Register  to view this content.

where the code assign the formula to the cell. I had replaced the formula with text but it still dont work. The range are used correctly as well. I will appreciated if there any help you can provide

Please Login or Register  to view this content.

Thank you so much . The code is worked perfect as it is