VBA Conditional Formatting Error (Subscript out of Range))

tinfanide · #1 04-23-2015, 05:41 AM

Views: 12 Size: 39.0 KB">ConditionalFormatting_Error_Subscript_out_of_Range.xls

I did more than one conditional formatting but when it reached the last one (in VBA), an error emerged.
Please see the codes in the attached file.

Could anyone point me to why the error occurs?
Thank you!

tinfanide · #2 05-15-2015, 08:12 AM

Found the answer. The ranges overlap.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting - color only dates contained in a range	EC37	Excel	1	07-08-2014 12:51 PM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Inserting Date, formatting to superscript and subscript	louq	Word	1	10-22-2009 09:29 AM
Subscript out of range error	KHTAY	Excel	6	03-28-2009 11:18 PM
Mysterious "Subscript out of range" error	rnstewart	Excel	4	12-29-2005 01:04 PM