The "Sales" reference is to a Named Range.

Easiest, if the sheet the range is on is NOT hidden and the Name doesn't
refer to an array constant:
Press the [F5] key.....Select Sales from the list.....Click [OK] to select
the range.

Otherwise:
From the Excel Main Menu
<insert<name<define
Select Sales from the list

Check the Refers To box for the referenced range.

Post back if you have more questions.

Regards,

Ron (xl2003, Win Pro)
Microsoft MVP (Excel)


"blucajun" wrote in message
...
I have a quote form that was created by a former employee and I need to
edit
a couple of drop down fields to add new and delete old sales reps. I have
never worked with drop down fields but after reading through this forum, I
understand that I can find the source when I go to Data Validation -and
look under the box for Source. However, rather than showing a range where
the list is contained, it shows =Sales. I don't find any other cells in
the
worksheet with Sales Reps, nor do any of the other worksheets contain this
info. I just don't know where else to look. Can anyone point me in the
right direction?