Excel problem (VBA)

[Evil Baby]

I don't know if anybody has a good grasph on excel and writing macros for it but I was trying to write a macro for work.


I got the macro to work fine on the first sheet, but when it goes to the second sheet even though the layout is the same I get an error of "400", and that's all.

I'm just doing conditional formatting but there are more than 3 conditions in some cases so I had to make a macro.


If you need to see the worksheet to understand what I'm talking about let me know.

Basically what is error "400"

[siriuskao]

[QUOTE=Evil Baby]I don't know if anybody has a good grasph on excel and writing macros for it but I was trying to write a macro for work.


I got the macro to work fine on the first sheet, but when it goes to the second sheet even though the layout is the same I get an error of "400", and that's all.

I'm just doing conditional formatting but there are more than 3 conditions in some cases so I had to make a macro.


If you need to see the worksheet to understand what I'm talking about let me know.

Basically what is error "400"[/QUOTE]

what's the full error message? Google Groups helped me solve a lot of VBA issues.

[url]http://groups.google.com/[/url]

[Evil Baby]

That's the problem, the error is just "400"
[IMG]http://i51.photobucket.com/albums/f367/rdonnell/error.jpg[/IMG]

[Evil Baby]

ok, I changed my code so that instead of running from one sheet and copied and pasted the code from the first sheet to the remaining sheets and it works no problem.


Any idea why it would give me an error if "400" if I do something like

Here is the code that I'm using

[url]http://www.rafb.net/paste/results/9oimc149.html[/url]

The error happens on line 6 when it gets to sheet # 2