I have a lot of workbooks actually that use indirect CF. Usually it's because I don't want to create a lot of formulas, so I can just highlight a large area, or areas and do an indirect that just looks at the corresponding row of a particular column. For example, let's say I want B2:B500 to turn yellow if anything but a zero appears in column D. That's where I've used an indirect CF, but then have to be sure I don't insert a column between B and D, which doesn't usually happen, but when it does it's most exasperating.
I have a form I created for our sales team that was designed to be somewhat idiot proof, as certain information was entered, other required information was highlighted, and incorrect information was flagged as such. The form was amazing until they started changing the rules on me, and then I started running into problems as I tried to redesign the form, one of the problems being my CF.
I am the kind of person that is constantly building, tweaking, and improving custom Excel applications that do the various tasks I have to do. So at one point I have it working beautifully, usually with significant CF, and then I have an "amazing" idea for a change I just have to do, and then there goes my CF.
I really appreciate your assistance, and I hope I'm not frustrating you. If I am, please feel free to move on from this subject- I won't take it personally.
Thank you Narayan!
Gary