Thread: Dynamic Named Ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete McCosh Pete McCosh is offline
external usenet poster
  
Posts: 14
Default Dynamic Named Ranges
set the source for the validation to =INDIRECT(B1) Or whatever the address or
name of the relevant cell might be.

Cheers, Pete.
Reply With QuoteReply With Quote