When hiding a row, how to avoid useless and long calculations ?
There is no way of avoiding the recalculations, except by changing to Manual
rather than automatic calculation mode. Look at http://www.DecisionModels.com/calcsecretsj.htm for some ideas on speeding up UDFs. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "MJ" wrote in message ... My user defined function often take several second to complete. When hiding some rows or column or when hiding in a list, Excel triggeres a recalculation. This is bad luck for me. Would you know if there is way to avoid that? Thanks, Michel |
All times are GMT +1. The time now is 03:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com