Help with running a macro in hidden cells

[Che6mw]

I have a spreadsheet with some hidden cells required for the function o
the spreadsheet, but that I would rather keep hidden to reduce clutte
on the screen for the end user.

When I run the macro which performs calculations in the hidden an
visable cells it is much, much, much slower to run when the cells ar
hidden versus when they are visable.


Any ideas why ? I'm talking something like 4 times slower to do th
same maths!

Any advice appreciated.

Mat

 

[Frank Stone]

is there a problem with unhiding the rows while the macro
runs then hiding them again at the end of the macro run.
I have done this with hidden columns before. it helps.

 

[Che6mw]

no problem ... but messy (many hidden cells). I just don't understand
how the macro can take so much longer to do the same thing for a hidden
cell as it is doing for a visible one ...


maybe it can't see what it's doing so it struggles