Fill formula according according Column c

[HaroonSid]

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

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[HaroonSid]

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

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[HaroonSid]

working fine

thanx alot

[JOHN H. DAVIS]

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