Run-Time Error 1004

[mattman123]

Hello all,

Please see my code below. It was working fine for awhile, but is now bugging out. Originally, it only bugged out at the highlighted and underlined code in case 13 whenever the first letter of the column numbers switched (e.g. AZ to BA), but now it is bugging out in every column. The error I'm getting is run-time error 1004. Any idea how to fix this?

Additionally, now the sub is inserting a "\" into the countif function, so you get: Countif(G\15:g\4,"<"&0). Any idea what it's adding the "\"s? Any ideas how to fix?

I deleted Cases 2 through 8 so that it would fit.

Thanks!
Mattman123

Please Login or Register  to view this content.

[mattman123]

More specifically, it's an application-defined or object-defined error.

[6StringJazzer]

Your 1004 is very difficult to diagnose without having your file. I would want to see the values of all those variables at the point where it stops. Can you attach it?

By the way, there are bugs in converttoletter when converting 79, 80, 105, 106, 107, and many more.

Try this. It lets Excel do all the work and has been thoroughly tested.

Please Login or Register  to view this content.