Well you may be right, but I'm not convinced. I just have a memory of
reading in previous newsgroup answers that this was a problem.

Rob


wrote in message
ups.com...
Shouldn't matter if i'm calling it by defined name



On Apr 18, 2:26 am, "Rob" wrote:
I'm not an expert and others may advise better, but I think having your
data
on another workseet may be the problem

Rob

wrote in message

ups.com...

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!