this should get you started:

http://www.j-walk.com/ss/excel/tips/tip47.htm

hopefully you know how to find the cells with the two dates you want.

--
Regards,
Tom Ogilvy


"tqm1" wrote:

Dear Sir,

I have following two columns as

--Date------Code
02-06-07----10
02-06-07----20
03-06-07----30
03-06-07----30
03-06-07----40
03-06-07----50
04-06-07----50
04-06-07----60
05-06-07----70
06-06-07----80
06-06-07----90

I wnat to fill Combobox1 with unique codes between Date 03-06-07 to 04-06-07

Please help