View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Boba Boba is offline
external usenet poster
 
Posts: 27
Default validation list from worksheet given by ref

"Tom Ogilvy" wrote in message
...
...
conceptually, it looks like you want to do validation to a list in a
separate workbook.


Yes. And i'm sorry for not beeing clear in my op
regarding Workbooks(1) and Workbooks("RefBookName")
- they are different workbooks. Giving the name
to the list has solved the problem.
Thanks for your reply. Boba.