How to autofill any formula till last empty cell

[nur2544]

Below code are some time working , & some time showing Autofill Method of Range Class Failed
Can anyone tell me how to fix it? or How to autofill any formula till last empty cell.

Please Login or Register  to view this content.

I also tried another way but not working

Please Login or Register  to view this content.

i have tried also like below but some time working some time not working , showing Autofill Method of Range Class Failed

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[nur2544]

Hi, Norie
You did really great job for me , it works excellent , thanks for giving your valuable time regarding this issue, take care..

[nur2544]

Hi, Norie
Would you please add one more line to keep value only except formula..

[Norie]

Like this perhaps.

Please Login or Register  to view this content.

[nur2544]

Hi, Norie
it is something what i was looking for..many thanks........