There is obviously a software glitch with Excel. I sometimes get the error and there are times I do not get the error running the same program with no changes. If I close the program and reopen it the problem remains. However, sometimes if I restart Excel it will correct the problem and the program will run OK for a while. Then all of a sudden I try to run the program again and "Run-Time Error '13' Type Mismatch". Aaaaargh!!! There is no type mismatch with the data. I checked and rechecked if there was some way I was mixing data types of had blank data. None!!! I've downloaded a fix from Microsoft for this problem but have had no luck installing the fix. I tried updating Windows XP to service pack 3, which is suppose to have the fix in it, but still get the error about 50% of the time. If anyone has found a solution to this software bug please let me know.
