Hi ,

I have a large sheet with multiple array calulculations looking at a large
number of rows. Once filtered the the specific user the numer of rows
visible is dramatically reduced, but the calculation time is still slow as
the hidden rows are also being calculated. Is it posssible to write a macro
to calculate only the visible cells (ie. not calculate the hidden rows)

Thanks in advance