Number-Text Type Mismatch?

[inkor]

Hi -

I'm running a relatively simple VBA procedure that is combining the contents of three different cell into another cell. After the routine was already working, I ran into a problem - Type Mismatch run-time error "13" .

After spending a while debugging this, I realized that the problem was only in *some* cases in which a cell was just numerals and no other text. When looking at the formatting of the cells, there is nothing consistently different about the ones with problems. Changing the problem cells' formatting to be exactly the same as those that work does not help.

With the first set of data that I was looking at, I noticed that of the cells that were just numerals, some of them were marked at the corners as having errors, and some were not. The ones that were marked as errors were the ones that were *not* having a problem. At one point I double clicked on a problem cell, it became flagged for an error, and was no longer a problem.

I find this to be very bizarre, that different cells act differently even though there are no apparent differences between them.

I'm using Cells as opposed to Range, though I don't think it should make a difference. Most of the problem cells use the font Georgia, though changing the font doesn't help. I tried copying the values and using Paste Special to just copy the values, but that also didn't help.

While I'm curious what caused this problem, my primary concern is to find a work-around. Any ideas?


Thanks,

Ryan

[mangesh_yadav]

Could you post your code with an example each of working and non-working case.

- Mangesh