I have workbook with approximately 50 Name Ranges that I have defined for my
Macros to Access. My macros used to work perfectly.

Yesterday when I activate the Macro, the macro gave me edebug messages. In
Excel, when I was verifiying the Name Ranges, about 20 of them defaulted to
#ref. I went an reset them up. They changed agian when I ran the macro.
Instead of referencing different cells, they all reference A1.

Is there a limitation to Name Ranges? Is there a way to keep the worksheet
referencing the correct cell?

Thanks
Dana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1