retrieve text from merged cells
 

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

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

David McRitchie wrote:

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

so "Cells(r, c).MergeArea.Cells(1).Value" would get the text from a column
of 5 cells where the top of that column had text typed in the cell and all
5 cells were merged? if the merge area is row 5 to 10 in column 2 then
Cells(5, 2).MergeArea.Cells(1).Value
Cells(6, 2).MergeArea.Cells(1).Value
Cells(7, 2).MergeArea.Cells(1).Value
Cells(8, 2).MergeArea.Cells(1).Value
Cells(9, 2).MergeArea.Cells(1).Value
Cells(10, 2).MergeArea.Cells(1).Value

would get the merged area text and not a "" value?
It seems to work, but I've only given it a superfical testing
Thanks
Eric

Hi Eric,
I expect that if you need the information, you will manage to pry it
out of the examples, by making your own little tests.

"Eric" wrote
would get the merged area text and not a "" value?
It seems to work, but I've only given it a superfical testing
Thanks
Eric