HI
I have a macro that runs whenever I refresh my worksheet. I also have
dynamic named ranges in the worksheet that I use for charts. Problem is that
whenever I run the macros to refresh the worksheet, two ofhte namved ranges
are erased. I've tried moving them to different parts of the workbook, or
redefining the names, and any of a number of things. They still get erased
every time I refresh the workbook. The really frustrating part is that it
only happens for these two named ranges, which only affect one chart.
Everything else runs perfectly.

Any idea what is going on here? I don't have much hair left to rip out..
TIA