Hi,

Thanks for helping.

In fact i have just tested the code and i think its placing the formula only on the column AY and not on the :
Range("AY59:EX" & lLR) = inarr

can you please just confirm.

thanks again for helping.