ClearContents of merged cell causes VB error

pilot · Apr 24th, 2002, 09:23 AM

I can select the merged cell, right click and ClearContents with no problem. But VB aborts with message "Cannot change part of a merged cell". Ideas on how to get around this?

jrnyman · Apr 24th, 2002, 09:33 AM

It's not a great way of doing things, but if you first "Select" the merged cell, then do clearcontents, it should work.

For example, if the merged cells are A1:A5:

Range("A1").Select
Selection.ClearContents

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 09:23 AM	#1
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	I can select the merged cell, right click and ClearContents with no problem. But VB aborts with message "Cannot change part of a merged cell". Ideas on how to get around this?

Apr 24th, 2002, 09:33 AM	#2
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	It's not a great way of doing things, but if you first "Select" the merged cell, then do clearcontents, it should work. For example, if the merged cells are A1:A5: Range("A1").Select Selection.ClearContents