Code to calculate only visible cells

[bradmcq]

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

 

[Patrick Molloy]

not if the hidden cells are part of the array formula that also include
visible cells

alternatively, why don't you use a filter to push the visible data to
another sheet then apply the formula to that that data...removing the formula
altogether from the 'source'?