Basic excel vba problem

[djurmann]

Hi folks,

I am trying to unmerge some cells in VBA....the code I have is this

Range("a3:b1433").Select.UnMerge

It does not work giving a runtime '424' object required response. What I wonder is what does this mean and why doesn't the code work?

Many thnaks,

Danny

 

[GlennUK]

Why have you got "Select" in your statement. You aren't trying to select the range.

 

[djurmann]

Hi Glenn,

What I am trying to do ultimately is this. Column a is merged into three rwo blocks e.g. a3:a5 is merged. a6:a8 is merged. I want to unmerge these cells, copy the text from cell a3 to a4 and a5. copy the text from a6 to a7 and a8, sort the column and then remerge the cells. I figured a good start would be to select the range and unmerge it.

Danny

 

[djurmann]

sorted the unmerge

It needed to be

range("a3:b1433").Select
Selection.UnMerge

 

[GlennUK]

I figured a good start would be to select the range and unmerge it.

... that's 2 actions, which you are trying to do in one statement.

For the record, most Excel actions can be performed without having to do a Select beforehand. So:

Range("a3:b1433").UnMerge

would have been a better start.

 

[djurmann]

ah many thanks