Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Type Mismatch Error #13
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Type Mismatch Error #13
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) "john431" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Type Mismatch Error #13
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 "Chip Pearson" wrote: 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) "john431" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Type Mismatch Error Need Help | Excel Programming |