>>Automation experts;

Thks+++ / all done :)


>>
>>Is there way to determine if single cell is part of
>>merged group of cells?
>>Also in how meny ROWS merged cells are spread.
>>
>>TIA / Anu help is greatly appreciated.
>
>You mean merged cells in Excel? If so, using H10 as a cell to check:
>

>mySampleCell = 'H10'
>with oExcel.ActiveWorkbook.ActiveSheet
>if .Range(m.mySampleCell).MergeCells && Is it merged?
>  loMergeArea = .Range(m.mySampleCell).MergeArea && range of merged cells
>  ? loMergeArea.Columns.Count
>  ? loMergeArea.Rows.Count
>  ? loMergeArea.Cells(1,1).Address() && top left
>  ? loMergeArea.Cells.Address() && whole area
>endif

Cetin