View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arup C[_2_] Arup C[_2_] is offline
external usenet poster
 
Posts: 32
Default How to make a dynamic named range

Hi everybody,
Can I make a named dynamic range? I am using data validation and made some
lists to work with but the problem is I have to change the range by the name
define command as I use a new list item. I have used the offset function to

create the dynamic list but is there any way to use a named list in that way?