Pop-up calendar not poping up on merged cells

[pincivma]

Hi There

I have a few pop-up calendars in my workbook. The calendars pop up fine if the cells are not merged. However on a merged cell (for example A1 and B1), the calendar does not pup up. I'm OK with that but I was just wondering if there is a way to make the calendar pop up on a merged cell. Just curious.

 

[Joe4]

Merged cells are notorious for causing issues in Excel, and should really be avoided whenever possible.
The good news is that you can achieve the same visual effect by using the "Center Across Selection" formatting option on A1 and B1 instead.
See: https://www.atlaspm.com/toms-tutori...er-across-selection-instead-of-merging-cells/

 

[pincivma]

Hi Joe4

I did not know this. Thanks for pointing it out to me. This will make my life a lot easier

 

[Joe4]

You are welcome!
Glad it was helpful to you.