Run-time error 13 - type mismatch when deleting data from multiple cells at once

[missnk]

Hi,

I’m currently making a simple macro for a spreadsheet. I have made a data validation list in some of the columns to automatically run a macro when selected to insert either the current time or the current date. It works perfectly normally, but the issue is that when I chose to highlight a block of cells in the spreadsheet and delete the data, a pop up opens and it says:

Run-time error '13':

Type mismatch


And when I hit on the debug option, it highlights the following code

Please Login or Register  to view this content.

The issue only arises when I try to delete data from multiple cells at once. Please help! Thanks

Please Login or Register  to view this content.

[stnkynts]

Correct me if I am wrong but you want it to do nothing if you delete data from multiple cells. If so try this:

Please Login or Register  to view this content.

[Trebor76]

Hi missnk,

Welcome to the forum (and to a fellow Sydneyite )

I think the issue is with the MacroInsertTime macro. Could you please post that code so we can get an idea of what's wrong?

Thanks,

Robert

[missnk]

Thanks, stnkynts! That's worked perfectly! What a relief! All I needed to do was add the code

Please Login or Register  to view this content.

Hi missnk,

Welcome to the forum (and to a fellow Sydneyite )

I think the issue is with the MacroInsertTime macro. Could you please post that code so we can get an idea of what's wrong?

Thanks,

Robert

Hi Robert!

The problem is fixed now but if you're interested, my macro for inserting the time is:

Please Login or Register  to view this content.

Thanks everybody I was starting to go crazy!