Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 --- "jen_writer" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge option is not available. How to undo merge in this case? | Excel Discussion (Misc queries) | |||
shortcut key for merge cell | Excel Discussion (Misc queries) | |||
UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
What is the Keyboard Shortcut of Merge and Centre Tool Command | Excel Discussion (Misc queries) | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions |