Hello,

I am trying to determine the best way to name cells automatically. I have a
worksheet named Shipper Pricing. It contains the price 7 different suppliers
charge us for delivery to over 70 destinations. As these may change at any
time, new suppliers added, new destinations added or old destinations
deleted, I cannot use absolute references, so must have each cell named.

I tried to use InserNameLabel to create cell reference names for each and
that appeared to work, as long as I was on the same worksheet, however, I
need those referenced names to appear on externally linked worksheets and
can't figure out to do that.

Pleae help. thanks.