pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 461
- Office Version
- 2016
- Platform
- Windows
I have a large spreadsheet with complex formulas that take a long time to recalc. When a user makes a selection in a menu, a number of unneeded columns are hidden (none of which are referenced by the remaining visible columns).
Within having the highlight the visible columns, is there code that would take the time to recalculate only the visible cells in the file?
Thanks!
Within having the highlight the visible columns, is there code that would take the time to recalculate only the visible cells in the file?
Thanks!