If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get macro to unmerge cells that have been previously merg
When I try to record the steps to unmerge 2 previously merged colums into 2
separate colums into a macro, when the macro is executed it tries to merge the colums instead of unmerging them? If I do the same steps without recording as a macro the unmerge works fine. Is there a trick invloved in recording a macro to do unmerging? |
#2
|
|||
|
|||
How do I get macro to unmerge cells that have been previously merg
Hmmmm not sure what's happening. Are you sure the cells you are unmerging are merged (probably a daft question), merge/unmerge is a toggle. Keyboard strokes are better than the mouse when using the record macro function, eg Ctrl+1 Alt+m Enter -- tghcogo ------------------------------------------------------------------------ tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494 View this thread: http://www.excelforum.com/showthread...hreadid=491561 |
#3
|
|||
|
|||
How do I get macro to unmerge cells that have been previously
thanks tghcogo....yes im sure they are merged. The manual unmerge works fine.
I looked at the macro code..and it did not have an "unmerge" command. I changed the code to select the columns and issued "unmerge" and it worked. So I dont know what is going on with the record macro function "tghcogo" wrote: Hmmmm not sure what's happening. Are you sure the cells you are unmerging are merged (probably a daft question), merge/unmerge is a toggle. Keyboard strokes are better than the mouse when using the record macro function, eg Ctrl+1 Alt+m Enter -- tghcogo ------------------------------------------------------------------------ tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494 View this thread: http://www.excelforum.com/showthread...hreadid=491561 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
(Excell) how do you unmerge cells once you have already merged th. | wbmIV | General Discussion | 1 | October 26th, 2004 05:11 PM |
Move selected cells to new destination via macro / formula / VB ed | Electroplastik | New Users | 3 | October 25th, 2004 04:52 PM |
Copy then Paste more than once | Steved | Worksheet Functions | 14 | August 18th, 2004 02:42 AM |
copying excel cells with link via macro | ikeriba | Powerpoint | 1 | July 9th, 2004 03:16 PM |
FILL CELLS = VARIABLE # OF OTHER CELLS (WITH MACRO) | Charts and Charting | 7 | January 7th, 2004 08:47 PM |