hello everybody
I selected 4 cells then merged into one
I want to detect that the merged cell is formed from 4 cells
please help
hello everybody
I selected 4 cells then merged into one
I want to detect that the merged cell is formed from 4 cells
please help
Not really (directly) possible. Once you merge cells, they are considered to be 1 cell, with the reference being the top left-most cell in that "range"
You might be able to do it indirectly though a count of adjacent cells (that contain data), compared to 1 (being the 1 merged cell)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
OK thanks my friend
Hi there,
The following code will detect how many single cells are contained in a merged cell:
Please Login or Register to view this content.
Hope this helps.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks