View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default Named ranges with dependencies

In , Roger Govier
spake thusly:

Hi Dallman

Obtw: what's the advantage to having "List" with all the
column headers rather than matching on Row 1 itself?


None really, except that I don't usually have my headers on
Row 1 and, I much prefer using named ranges to row or column
references. I nearly always leave 5 rows free at the top of
any sheet I am setting up, in case I want to use them for other
things e.g. placing subtotals there.


Okay, I'm with you. Thanks very much for the good explanations
and help!

Dallman