Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Eric
 
Posts: n/a
Default 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
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

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



  #3   Report Post  
Eric
 
Posts: n/a
Default

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
  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make Autofit row height work with merged cells Franketh Excel Discussion (Misc queries) 2 April 6th 05 09:13 PM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 01:22 AM
Autofit row height in merged cells BobT Excel Discussion (Misc queries) 1 February 25th 05 05:44 PM
Adding two text cells together Audrey Excel Discussion (Misc queries) 4 February 24th 05 10:57 PM
Excel merged cell - can it automatically expand as text is typed? Joanne (JAS) New Users to Excel 2 January 8th 05 01:11 AM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"