merge shortcut undo

[Guest]

Hello,
I recorded a macro to create a keyboard shortcut for merging cells. It works
well, but after I have merged cells, I cannot hit "undo" if I change my mind.
I have to use the unmerge command, which causes me to lose borders, etc in
the newly unmerged cells.

Is there a way to create a merge shortcut that can be reversed with "undo"?

thanks
Jen

 

[Guest]

Hi,

the site http://www.jkp-ads.com/Articles/UndoWithVBA00.asp has some
information on this, but the procedure is not a simple one.

hth