| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to unmerge columns
A recorded macro for unmergin 2 merged columns in a worksheet doesnot work.
It tries to merge the cells again and as a result wipes out the data. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to unmerge columns
Show us the code.
Gord Dibben Excel MVP On Wed, 7 Dec 2005 10:42:02 -0800, "HankY" wrote: A recorded macro for unmergin 2 merged columns in a worksheet doesnot work. It tries to merge the cells again and as a result wipes out the data. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to unmerge columns
I dont have the code available right now(at home) but the code in the
recorded macro had a"merge" command in it. I changed the code to select the columns and did an "unmerge" and it worked correctly. If I go thru the same steps without recording the macro..the columns/cells are unmerged correctly. "HankY" wrote: A recorded macro for unmergin 2 merged columns in a worksheet doesnot work. It tries to merge the cells again and as a result wipes out the data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get macro to unmerge cells that have been previously merg | New Users to Excel | |||
| Editing a simple macro | Excel Worksheet Functions | |||
| Can T Get Macro To Run! | New Users to Excel | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
