Merged cells

Merged cells

Posted by: brbrayan2010 on 1 October 2018, 2:56 pm EST

• 

  brbrayan2010

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 October 2018, 2:56 pm EST

  Hi, for all

  Im testing your great code. I would like know if your code have any option for get the list of cells (ranges) merged on a range, I try but only found options for merge cells,
  
  but not found any option for check if cells is merged, and can get the ranges merged.

  thank you for your reply

  regards

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 3 October 2018, 1:51 am EST

  Hello,

  You can use the code snippet at this link to find out if a cell contains merged range or not:
  
  http://demos.componentone.com/gcdocs/gcexcel/#/GrapeCity.Documents.Excel.Examples.Features.CustomFunctions.MyIsMergedRangeFunction

  Further, to obtain the range of cells merged, you can use the MergedArea property (http://help.grapecity.com/gcdocs/gcexcel/onlinehelp/webframe.html#GrapeCity.Documents.Excel~GrapeCity.Documents.Excel.IRange~MergeArea.html) as follows:

  Dim range As IRange = worksheet.Range("A1").MergeArea
  
  

  Hope it helps.

  Best Regards,
  
  Esha

• 

  brbrayan2010

  • Post Options:
  • Link
    Copy

  Posted 3 October 2018, 10:25 am EST

  thank you for your help

  Regards