Hi Eric,
Once a cell is merged the parts that you do no see no longer exists,
only the content of the upper left cell of the merged cell survives.

So I'm not sure what the question is. If you want to see how I
handle merged cells in converting an Excel selection to an
HTML table see http://www.mvps.org/dmcritchie/excel/code/xl2htmlx.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Eric" wrote in message ...
I have several cells in a single column merged into one cell.
Before merging the top cell had text and the other cells in the "to be"
merged area had no text. Then i merged them. ok so far.
Now i have a macro that iterates down the rows. some rows are ordinary rows
and in some places they are part of a merged area (in a single column)

My question is: How do i read the text in the merged cell?

str = Cells.Item(mRow, mCol).Value sometimes produces str==""
when it hits a row that contains part of a merged cell

str = Cells.Item(mRow, mCol).MergedCells.Text is the kind of thing i need.
How do you do that?

Thanks
Eric