I never used it like your range, always with cells in the same row.

Sorry, I can't help you


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"Ron Rosenfeld" wrote in message ...
On Thu, 6 May 2010 21:41:22 +0200, "Ron de Bruin"
wrote:

Never use Merged cells Is all I can say, only trouble.

Use Center across selection instead

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

I'm not sure how to apply your advice.

For example, in the data, E14:E16 is a merged cell, as is H14:H16.

The separate lines of data in F14, F15 and F16 each refer to the data in the
merged cells on either side.

How do I associate the data in the merged cell, with each of the line items,
without using the merged cells?

--ron