ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MergeCell performance (https://www.excelbanter.com/excel-programming/384580-mergecell-performance.html)

snoriidr

MergeCell performance
 
Does anyone know of the performance impacts of doing 1000's of MERGECELL api
calls to ranges in a worksheet??

Basically I am trying to determine the impact of MERGECELL calls because I
have a program that requires ~18000 merges of different cell ranges. It
seems the more times MERGECELL is called the slower it gets over time.

Is there a memory issue in Excel with regards to defining mergeCells?

Thanks for your help


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com