Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unmerge cells and place contents of first cell in all cells
I have several merged cells in a column. I would like to take merge cells
C2, C3, C4, C5 and C6 and unmerge those cells AND take the contents that is in cell C2 and place in the remaining four cells. I have several sets of these and the merged cells all contain different info. Can I use a Macro for this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unmerge cells and place contents of first cell in all cells
This should help get your started.
Sub Macro1() Range("C2:C6").Select With Selection .MergeCells = False End With Range("C2").Copy Range("C3:C6").Select ActiveSheet.Paste End Sub Paul "Amanda" wrote in message ... I have several merged cells in a column. I would like to take merge cells C2, C3, C4, C5 and C6 and unmerge those cells AND take the contents that is in cell C2 and place in the remaining four cells. I have several sets of these and the merged cells all contain different info. Can I use a Macro for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unmerge cells? | Excel Discussion (Misc queries) | |||
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? | Excel Discussion (Misc queries) | |||
How do you unmerge cells | Excel Discussion (Misc queries) | |||
Spreadsheet with merged cells - how can I unmerge the cell and re. | Excel Programming | |||
How do you unmerge cells? | Excel Discussion (Misc queries) |