create macro "merge selected cells"?

[Mamoudou]

I want to create macros that relate to selected cells, not absolute or
relative references; specifically, merge and unmerge selected cells. Excel in
Office 2003, Win XP.

 

[Mike H]

Maybe this in a module

Sub merge()
response = InputBox(" Merge...(m) or Unmerge...(u)")
Select Case UCase(response)
Case "M"
Selection.MergeCells = True
Case "U"
Selection.MergeCells = False
Case Else
MsgBox "Enter M or U"
End Select
End Sub

Mike

 

[Dave Peterson]

How about just recording a macro when you do it manually?

 

[Mamoudou]

How about just recording a macro when you do it manually?

 

[Dave Peterson]

Share your recorded code.

Sometimes, it's a simple change.

Changing a specific range("a1:x1") reference to Selection may work.

 

[Mamoudou]

Thanx for your interest. I have never used code, only recorded the
keystrokes. I should try that, as in the post above. Why is there no keyboard
shortcut?

 

[Dave Peterson]

In xl2003, there is an icon on the Formatting toolbar.

I have no idea why MS decided not to include a keyboard shortcut.

Thanx for your interest. I have never used code, only recorded the
keystrokes. I should try that, as in the post above. Why is there no keyboard
shortcut?

 

[Mamoudou]

Thanx, that'll do. That's as simple as using a macro and a lot easier than
creating one. Thanks for all your help.