VBA type mismatch array and cell .

First of all, don't know yours, 2).Whether sheets(1) in the value is written incorrectly (whether it is sheet1 or not).

Secondly, I have tried it, and this method is possible. If you really can't do it, you can also consider using a string variable to get the value of cells(2,2) and then use the function val to convert it to integer.

If you sheet(1).The display data in cells(2,2) is not integer, it will be wrong, because you have defined the type of the array variable as integer in **, you can remove the as integer in the first sentence, and you can use any type. Namely:

dim datanum(4)

,2) if the numeric property is not integer, it will be wrong.

Most of the time, excel can automatically convert numeric types, but I have also encountered situations where "just" does not convert for you, and I don't know why.

So, in ,2).value with a cast function.

is a way to avoid trouble.

It is recommended to use cint(,2).value).

The types in the VBA do not match, and it is possible to compare, or two different types are used in the calculation, resulting in a failure to match.

For example, if you compare an object to a text, it won't match.

For example, in Excel, adding a worksheet object and a numeric value will prompt a mismatch of types.

Also, if you multiply a number by a text and do so, it will also give you an error.

Check it out. Objects all have attributes. For example, if you want to compare whether the name of an object is the same as a text, you can use the object properties to extract the name of the object and compare it with the text.

e.g. if ="Create a new file" then

end if

That's okay.

If the object is an object, you use the following statement if object ="Create a new file" then……end if

That's what went wrong, the type didn't match.

It's not easy to type on your phone, if you understand, please give it a thumbs up.

**Take a screenshot to help you find out the reason.