VBA to apply conditional format

Hi all,

I am applying several conditional formats to a sheet with macros. All of them are set up successfully but the one below:

Please Login or Register  to view this content.

I get a run-time error 1004. I assume there's too many ranges referenced? I tried Union(Range( as well, but no luck...

Try reducing the number of ranges and see if you get the error.

I tried before and it worked! Hence, I assume the number of ranges causes the error...

Is it possible there is a syntax error in one of the ranges?

I found on another forum that the number of ranges maximum is 16. (EDIT - may not be accurate on second look).

And recommend using UNION to join the ranges.

Originally Posted by kersplash

I found on another forum that the number of ranges maximum is 16. (EDIT - may not be accurate on second look).

And recommend using UNION to join the ranges.

Would using Union increase such a potential maximum?

The address that you pass to range can't be longer than 255 characters - yours is 392. Even if you remove the unnecessary $ signs you are left with 292, so you do need to union 2 ranges, or apply the CF in two blocks.

How would such a Union Range look like? I tried:

Please Login or Register  to view this content.

But it gets me a "Object doesn't support this property or method" error...

Union is not a worksheet property. You should use:

Please Login or Register  to view this content.

Thank you!! That works