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