Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

Anytime I delete more than one cell, row, col, etc. I get error????

Posted by Taylor Lynn on January 26, 2002 8:35 AM

I do have some macros in my system. Now, anytime I try and delete more than one of anything I get a

run-time error '13': type mismatch.

Anyone have a fix or know why?
Thanks so much in advance.
Taylor Lynn

Re: Anytime I delete more than one cell, row, col, etc. I get error????

Posted by Jack in the UK on January 26, 2002 10:57 AM

Hi Taylor Lynn--
Do your Scripts protect cells?
If so they could be getting grumpy thus the error.

Are have the codes running on these cells as targets or custom functions?

Jack

Better to post your code so it can be checked.

Posted by on January 26, 2002 8:04 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.