incompatible types
Hi,
I have the following program:
But, to reach the highlighted line generates compile error 13 - incompatible types. The return of instr is an integer type, but stated (aux1, aux2, aux3) as variant, string and long and still generated error. Could anyone help me?
Please Login or Register to view this content.
The problem is that you've only used 3 arguments of InStr.
If you are going to use the last argument Compare you need to use the first argument Start.
Start requires an integer.
Either remove the ,1 at the end or add 1, at the start.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Ok! Worked! Thanks!!
Might also be useful being explicit in your declarations, in the below, only layermm is a string:
The above is the same as:Please Login or Register to view this content.
VBA unfortunately requires that you do the below:Please Login or Register to view this content.
Please Login or Register to view this content.
Ok! Thank´s, now i understand!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks