Thread: Unmerge cells and place contents of first cell in all cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amanda Amanda is offline
external usenet poster
  
Posts: 151
Default 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?
Reply With QuoteReply With Quote