i have in column A:A a various list of dates in the following format

12/08/2006 Saturday

I want to create a list of the available months in column A:A to use in
a drop down menu.

This is a general format so ive not been ale to go for the max numeric
value although i can do a datevalue function(leftx,5)) to get the value
and then find the max date but this causes the workbook to slow as i
would have to run this against 9 imported worksheets. Also the rows
used vary on different imported time ranges.

As the dates are in acending order and the last date is always a given
number of rows from the end i wondered if there is a way to find out
how many rows had been used. There are also blank rows in between so
ive not been able to go down this road.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515