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
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread:
http://www.excelforum.com/showthread...hreadid=511571