retrieve text from merged cells

E

Eric

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
 
E

Eric

David said:
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

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
 
D

David McRitchie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top