Runtime error 9 with conditional format macro

[Subject_Name_Here]

Hi. I have a macro that first deletes the present conditional formats on the tab and then creates a new one. When I run the code, I get "Run-time error 9 - Subscript out of range and it highlights the line "Columns("H:H").FormatConditions(Selection.FormatConditions.Count).SetFirstPriority". Why is this happening and how do I fix it? I've tried inserting selection instead of columns("H:H") with no luck. The strange thing is that sometimes (1/5 times) this code runs fine. Any insight would be appreciated. Thanks!

Please Login or Register  to view this content.

[arlu1201]

If you use the With command, the statements between the With and End with like Range, Columns, Rows, etc should have the . (dot) in front of them.

Try this

Please Login or Register  to view this content.