macro interrupted error 2029

[radame]

Hello

I have a code that is interrupted in the middle of the process (marked in red) and I get a Runtime error !13!
Tyme mismatch

If I stop the code and then I run the macro again it runs without a problem and update value in cells afeter IF

Any help on this will be appreciated

Please Login or Register  to view this content.

[MarvinP]

Hi,
Perhaps you are getting an error because in

Please Login or Register  to view this content.

formver is a number because you did a ".Value" and then you check it against a String in the next line.

Try changing the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Which line did it stop on? I don't see any red in your message.

[Leith Ross]

Hello Marvin and radame,

FYI
Using colored text inside a Code Pane does not work anymore. It used used to work until the site was upgraded. Unfortunately, despite numerous complaints the problem has never been corrected. However, Bold Text does work.

[protonLeah]

Did you post the entire code for that Sub? Why three "End If's" and only one If?

[radame]

Hello

MarvinP
I tried with that option and it does not work, hopefully we found another solution, we decide not to perform that comparison and just work with new files (2011)

Leith
Thanks for the tip, I will consider it for the next time

ProtonLeah
You are right, the Sub is not complete, I just posted the part with the problem and related info of that portion.

Thanks for the help