Overflow error on worksheet_selectionchange when counting selected cells

Hi,

What I want to do is pretty simple. I have a sheet where I have a calendar form called when the user selects a specific cell. Now this cell is merged together with 4 other cells for a total of 5 cells. I know how everyone feels about merged cells but given the way my sheet is laid out it was unavoidable. Basically it is a time entry sheet. So I have a worksheet_selectionchange event that calls the calendar when you select the cell. This code is fairly simple.

Please Login or Register  to view this content.

This code works as expected and will only call upon the calendar if W5 is selected. The issue I have now is that if i were to select all cells (top left corner box) I get a run-time error 6 - Overflow on the line:

Please Login or Register  to view this content.

I have also tried using the following code:

Please Login or Register  to view this content.

And again i get the same error on the top line where it says target.cells.count = 5

I have code that copies the entire sheet over by selecting the top left corner box which is why i need this fixed otherwise i wouldnt care

Any help on this is appreciated.

Thanks!