Don't do it!

Merged cells cause nothing but trouble--try filtering/sorting/charting with
merged cells and you'll see.

If all you want to do is hide those values so it looks pretty, then Debra
Dalgleish shows how:
http://www.contextures.com/xlCondFor...html#Duplicate

Josh Craig wrote:

Hi,

I posted earlier today but I have another related question. I have data
like this:

column A: column b:
red 1
red 2
red 4
blue 12
blue 7
green 9

I need a macro to merge the cells in column A where they have the same value
so instead i would get:

column A: column b:
red 1
2
4
blue 12
7
green 9

Any ideas?

--

Dave Peterson