Problems with dynamic ranges and Indirect function in Excel - TechRepublic
General discussion
June 18, 2007 at 06:52 AM
jeffrey.ccs

Problems with dynamic ranges and Indirect function in Excel

by jeffrey.ccs . Updated 16 years, 2 months ago

I have been using dynamic ranges for sometime and also separately using the indirect function to reference static ranges. Now I am trying to combine the two and for some reason they will not function. When creating the list in data validation, excel brings up the message box “the source currently evaluates to an error”.
If any one has had a similar problem I would be interested to hear if they found a solution.

This discussion is locked

All Comments