Self-solved
Printable View
Self-solved
Out of curiosity, what were you trying to do? And how did you solve it?
In the past I created a complex named range via code and I wondered how I did it because I needed to do it again. I solved it when I realized that all I needed to do was to record a macro while creating it using Home->Conditional Formatting. Note that when you do that you get the code for all the worksheet's conditional formatting rules.