Thanks everyone for your feeback.

For the performance issue I had this filled down 500 rows and was an it took a few seconds tro update. This isn't an issue when I use standard excel functions.

I must say i achieved the best results with Tom's suggestions, recalc is now fine, is not slow etc.

Regards,

Max