| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge cells
How do i merge cells using code, is it possible?
I would like to mergecells as follows ActiveCell.Offset(0, 8) and merge it with the 2 cells below, if poosible, also change the colour to cyan. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
merge cells
Range("A1:A3").Merge
Range("A1:A3").Interior.Color = vbCyan If this post helps click Yes --------------- Jacob Skaria "Woodi2" wrote: How do i merge cells using code, is it possible? I would like to mergecells as follows ActiveCell.Offset(0, 8) and merge it with the 2 cells below, if poosible, also change the colour to cyan. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
merge cells
Sub demoTest()
MergDemo "A1:A3" End Sub Sub MergDemo(target As String) With Range(target) .Merge .Interior.Color = vbCyan End With End Sub "Woodi2" wrote: How do i merge cells using code, is it possible? I would like to mergecells as follows ActiveCell.Offset(0, 8) and merge it with the 2 cells below, if poosible, also change the colour to cyan. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically merge mulitiple cells to one cells | Excel Worksheet Functions | |||
| Select Merged Cells and Unmerge Spread Merge Data To All Cells | Excel Programming | |||
| how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
| How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel? | Excel Programming | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Linear Mode
