View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kari Kari is offline
external usenet poster
 
Posts: 16
Default Retain value of merged cell in all unmerged cells

I have a table with a column of data that has merged cells with a value in
it, I would like to unmerge the cells, but retain the value of the cell in
all of the unmerged cells instead of only the top cell. Is there a way or
macro to do this?