Merged cells are just a pet peeve of mine.

I should shut up about it but some users think the feature is the best thing
since sliced bread and populate their sheets with them.

Then post here wondering why they can't do this or that and are getting error
messages.

I have not tried 2007 yet but maybe some improvement has been made?


Gord

On Sat, 9 Dec 2006 11:46:01 -0800, Ron Coderre
wrote:

Succinctly put, Gord....
I abandoned writing my comments on merged cells when I was starting Chapter
3 of my intended post. <vbg

***********
Regards,
Ron

XL2002, WinXP


"Gord Dibben" wrote:

Your only mistake is using "merged cells" feature.

Merged cells cause no end of problems with copying, pasting, sorting, filtering
and a host of other functions and should be avoided at all cost.


Gord Dibben MS Excel MVP


On Sat, 9 Dec 2006 04:09:00 -0800, Rishi
wrote:

Dear Ron

i must say you are a Genious, and Thanks a lot for the Code you have given.

But one thing i have noticed that if the DV is in a Marged cell ( C6:D6 )
then the code didn't worked, (i've changed the code Range as C6:D6 also)

is it a programme difault or i'm doing any mistake.

once again thank you for the help


Regards

Rishi