Adamski
01-08-2010, 07:13 AM
Hi,
I have a named range "DateAll" which is one row and a number of contigious columns. These cells contain ascending dates (1st of the month) of date type. I have two other named ranges "DateStart" and "DateEnd" which are individual cells containing a value from "DateAll".
I can loop "DateAll" to find the start and end cells but there must be a better/faster way (It has many columns and I need to do this often).
So, in VBA how do I get a range object of the subrange of "DateAll" from "DateStart" to "DateEnd"?
Thanks
I have a named range "DateAll" which is one row and a number of contigious columns. These cells contain ascending dates (1st of the month) of date type. I have two other named ranges "DateStart" and "DateEnd" which are individual cells containing a value from "DateAll".
I can loop "DateAll" to find the start and end cells but there must be a better/faster way (It has many columns and I need to do this often).
So, in VBA how do I get a range object of the subrange of "DateAll" from "DateStart" to "DateEnd"?
Thanks