Autofill VBA till last data (destination) of column

[Mehmud Khan]

Hello everyone....
Hope doing well !

While working on a VBA project, i stucked at very simple stage. Actually I recorded the macro to autofill a formula, but with the recording mode the destinations of last column also get locked.
I have attached an example file as well as VBA codes. Could anyone look on this please ........

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Mehmud Khan]

Hi Narayan,

thanks for your interest, your work is really appreciable. but I need one more modification. Check the attachment again, hope you understand ...

 

[NARAYANK991]

Hi ,

I am sorry but I have not understood what you want ; can you explain ?

See the attached file for the modified code which copies the formula to the correct number of cells.

Narayan