Fill formula according according Column c

hello
i m using below code to fill formula

Please Login or Register  to view this content.

but in above code i want little change

Please Login or Register  to view this content.

this code paste data only according column c

i mean if i have data till C160 then formula paste only

Please Login or Register  to view this content.

thanx a lot

Try:

Please Login or Register  to view this content.

Hello JOHN H.DAVIS
Thanx alot perfect

one more query

i want when i type in c10 then formula auto fill till

Please Login or Register  to view this content.

, i mean with out using button

Maybe:

Please Login or Register  to view this content.

working fine

thanx alot

You're welcome. Glad to help out and thanks for the feedback.