Thread: [Solved] Data Validation - List
View Single Post
 
Old 03-08-2016, 06:18 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
That's never happened to me, but try one of these:

* Specify the sheet in the range e.g. =[Worksheet 2]!A1:A50
* Use a named range
Reply With Quote