how to get merged cell values to unmerged cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top