View Single Post
  #1   Report Post  
Old March 26th 15, 06:49 PM posted to microsoft.public.excel.worksheet.functions
Håkan Björkström Håkan Björkström is offline
external usenet poster
First recorded activity by ExcelBanter: Jan 2013
Posts: 8
Default Excel named tables or dynimac named ranges?

I have Excel projects using a lot of small lookup ranges - also large worksheets. I have a question about advantages/disadvantages of named tables and dynamic named ranges. At first sight it seems that named tables supersede the dynamic named ranges, but I think it's not quite true.
Can anyone shortly explain the advantages/disadvantages of those two?