HotXLS Docs
Home Contents Overview

MergeArea property

Returns a Range object that represents the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell. Read-only IXLSRange.

Syntax

property MergeArea: IXLSRange;

Example

This example sets the value of the merged range that contains cell A3. 

With Workbook.Sheets[1].Range['A3','A3'].MergeArea do begin
  Item[1,1].Value := inttostr(Rows.Count) + ' x ' + inttostr(Columns.Count);
end;