Hello everyone
I have in my attachment the sheet("Temp")
In range("A3:AA7") there are a lot of merged cells
I need a code that check every cell within the range and if the cell is merged cell >> the code to unmerge the cell ..
This step I can do it ...
But I need also to copy the contents of the merged cell to both the cells ...
For example :
In B3 (merged cell) the text "Science"
After unmerging this cell , the text is in B3 only and as for C3 is blank .. Now I need to have the text "Science" in C3 also
Hope it is clear
Thanks advanced
Bookmarks