Dynamic Named Ranges Dynamically changing on their own?!

[3G]

Hi there-

I have a few columns of dynamic named ranges, all of which have the refernce set to:


OFFSET(Reference, 0,0,COUNTA(Col:Col),1)


When I am clicking within another series to create/add an additional dynamic named range, the ranges of previous existing ones are changing ther values!? For example,

=OFFSET(MasterLOE090111!$B$5,0,0,COUNTA(MasterLOE090111!B:B),1)

becomes

=OFFSET(MasterLOE090111!$B$5,0,0,COUNTA(MasterLOE090111!XFD:XFD),1)


This is very puzzling. Anyone have any ideas?

 

[Luke M]

You probably need to make the B:B reference absolute (add the $'s) so that the reference doesn't change depending on which cell is selected.

 

[3G]

oh brother...that was easy!


thanks Luke.


where is the embarrassed emoticon when ya need it?