Strange Type Mismatch Error #13

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This one is really puzzling. I have two VBA procedures. One sets up a
spreadsheet with dates as column headings. The last column has formulas to
sum up the integers inserted manually in each row. The second procedure
clears the spreadsheet. Every time I type an integer into a cell, the "Type
Mismatch" error message appears. The VBA Editor also pops up. I am not even
running the procedures and this error appears. Any suggestions?

John431
 
It sounds to me like you have a Worksheet_Change procedure that runs
automatically whenever a cell is changed. Look in the Sheet code modules and
the ThisWorkbook code module for a Change event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Thanks for your response, Chip.

I checked for code in the project and saw nothing to cause it. Nothing in
my procedures that I could identify. I went back to some original code
which resolved that problem. Something in the later revisions to the code
caused the problem. However, I am still puzzled by what it was.


John431
 
Back
Top