Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I do Excel programming first time, and I create a program to detect merged cells , by this way: 1.Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); 2.Get every cells in the worksheet, and check it is merged cell, or not. €»There is one worksheet in the Excel only. but the worksheet has 60 columns and 10000 rows. and it take long time to finish detecting a worksheet. Is there any better way to do it? Best, Mars |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with pasting special merged cells to merged cells | Excel Programming | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
VBA: How to detect whether two cells are currently merged | Excel Programming |