Hi ,

i have tried the above code but when running its placing the formula only on column AY and not on the Range("AY59:EX" & lLR) = inarr.

Can you please check and advise if this is the case as i have run it several times and it continue to place it on the column AY only.

thanks again for helping.

And i really need to figure out on this problem as we are suppose to present the planning to the department by next week but just because of the time its taking we are squeeze right now.

I would be very grateful for the help and recommendation on that,.