Inserting array formula for dynamic range via VBA

Dear All,

I am not able to insert array formula for in Column H in one stork.

Please Login or Register  to view this content.

To overcome this issue First I entered array
Formula in cell H2 and then copied down.

Please Login or Register  to view this content.

This is working for me.

But in the given data row number keep changing. How could i make it dynamic.

In this case there are 953 rows. Formula will not work if data is more then 953 rows.


Vba code is as follows,

Please Login or Register  to view this content.

Kindly help.

Regards,
PN

Dear PCI,

It's on target. Many thanks.

Regards,
PN