Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate cells within merge area
for charting purposes i need to populate cells within a merged area in my code.
If myrng is the merged area and myrng.cells(1) contains mydate then... I've tried dim cl as range dim myrng as range set myrng = Range("MergedRange") for each cl in myrng.cells cl.value = cl.MergeArea.cells(1).value next cl unfortunately, all cells in the merged range remain blank except for cells(1) I've noticed that I can manually populate all cells in a merged range by copying a value and then using pasteSpecial/formulas. In lieu of any better sugestions i'll write code around this principle Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Merged Cells and Unmerge Spread Merge Data To All Cells | Excel Programming | |||
Location of Cell with Value in Merge Area | Excel Programming | |||
How to merge all selected areas into one area | Excel Programming | |||
how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) |