Vba for multiplication

Hi I have below code.

Please Login or Register  to view this content.

In above code in last created Column H, I wanted to change the cell number of total value

At present the valuse of C divided by cell C12. But I wanted to Change the code where Cell c12 to be the last of the Column C.

For formula example refere sheet "Result" Column H.

How many threads are you going to open for the similar qestion?

If you don't want me to reply, DO NOT use the code I gave.

Dear Jindon.
I owe you. But you should see my response. I have given a reputation to all your replies. It clearly says that I have responded to your question.

Since I am not good in excel, I am seeking for help from the forum for even single and small changes.

Thank you sir.

Thanks a lot. Please note My intention is not wrong.

Since I am weak in Excel I am posting everbodys code on forum as per my requirment.