and actually...some of them WILL be in different worksheets... :/

On Nov 14, 4:35 pm, "Nigel" wrote:
ok .... so i need to make a custom drop down....

the actual drop down will be nowhere near the data that it is pulling
from (although it will be in the same sheet) so standard list, or
autofilter options are out....

the dropdown needs to list only unique names in a given range

and the range needs to be determined by variables...ie Range("A" & LPS
& ":F" & LPE)
where LPS and LPE are variable row numbers.....

im banging my head against a wall to figure this out......