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.
Bookmarks