S
Simon Lloyd
Hi all,
Does anyopne know how to keep a named range between two dates?, i have
a couple of named ranges and for one reason or another interfere with
each other when new rows are added, as the new rows that are added
contain a date and are sorted by date i was wondering if i could
restrict the named ranges to operate between certain dates i.e 1/1/06 -
5/5/06 could be named range 1 etc for all 3 named ranges i have.
Anyone got any ideas?
cheers,
Simon
Does anyopne know how to keep a named range between two dates?, i have
a couple of named ranges and for one reason or another interfere with
each other when new rows are added, as the new rows that are added
contain a date and are sorted by date i was wondering if i could
restrict the named ranges to operate between certain dates i.e 1/1/06 -
5/5/06 could be named range 1 etc for all 3 named ranges i have.
Anyone got any ideas?
cheers,
Simon