LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I unmerge cells? GregB Excel Discussion (Misc queries) 3 July 25th 08 10:39 PM
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? lowell Excel Discussion (Misc queries) 1 August 20th 06 09:10 AM
How do you unmerge cells Freddo Excel Discussion (Misc queries) 1 June 7th 06 05:01 PM
Spreadsheet with merged cells - how can I unmerge the cell and re. Dotgale2 Excel Programming 1 February 2nd 05 01:57 AM
How do you unmerge cells? Pank Mehta Excel Discussion (Misc queries) 1 February 1st 05 02:29 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"