Chart data from merged cells.

G

Guest

How do I get data from a row of several groups of merged cells. Even though
the cells appear to be one cell, the chart wizard reads every cell in the
group with the data that I need being in the top left cell of the merged
array. I hav a row of nineteen 3X3 merged arrays.
 
A

Alan

Without seeing the sheet its hard to say, but merged cells should be limited
to text and suchlike as far as possible, formulas and VB code do not get on
well with merged cells,
Regards,
Alan.
 

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

Similar Threads

Count with merged cells 2
sorting two columns of merged cells 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
VBA set thick borders around non empty cells in range 0
Automatically color merged cells 1
Help with merged cells 1
Link Merged Cells 3
Insert Row and keep merged cells formatting 1

Top