how to get merged cell values to unmerged cells

[Guest]

I have a merged cell A3 (by merging A3:A6) having numeric value 27:

If I Unmerge these cell A3.... I should get all cell values ( A3, A4,A5,A6) should be 27

Instead of that I am getting A3 cell value only 27 rest of the cells are blanks. (Which normally happens in excel

My requirement tis A3, A4, A5, A6 should be filled with 2

seeking the solution plz...can any body help me out

Thanx in Advanc

 

[Andy Brown]

My requirement tis A3, A4, A5, A6 should be filled with 27

If you mean you want that this should happen automatically, then I don't
think it can.

You could press F2 followed by CTRL+Enter straight after unmerging.

Or you could try code,

With Selection
..MergeCells = False
..Cells.Value = ActiveCell.Value
End With

Assigning it to a custom button would be as quick as using the UnMerge
button or going through the menus.

HTH,
Andy