Determine if range of cells is already merged cells, all unmerged or combination

[Mitchw82]

Hello,

I'm relatively new to excel vba coding and I'm writing code to help with a planning/scheduling sheet. The user will highlight the cells he wants to merge (columns indicating hours of the day), and then uses a keyboard shortcut to initiate the macro. The macro needs to be able to determine whether the range of cells the user highlights contains all unmerged cells, is already a single merged cell or is a combination of merged and unmerged cells.

I'm not sure how to do it, but I'm thinking of stepping through the range of cells one by one to see if it notices any cells which are merged or not; however, this seems quite memory intensive and slow. Does anyone have an easier way to do this?

Regards,
Mitch

[ARowbot]

This Code will check all of the selected cells.

Please Login or Register  to view this content.

If you want me to change it to check coloured cells then please give me more information in regard to the colour it will be shaded and any limit to the range that could be shaded (Checked)

Thanks
ARowbot

[Mitchw82]

Hi ARowbot,

Thanks for your help. I was able to get something working using my original idea, but it isn't the most efficient. Here is is below:

Please Login or Register  to view this content.

I'll clean this up with some of your code.

Thank you!