Hi there

I have multiple Formula Arrays in a worksheet that I need to refresh regularly. The manual way is to control-shift-enter each array but this is getting quite tedious.

Does anyone know some vba that I can attach to a button that will refresh all Formula Arrays in a worksheet? I have seen this before so I know it can be done but I can't remember how!

Any help most appreciated

Cheers

Ramon