Not familiar with the date picker, but you can get the first empty cell with

Set cell = Range("A1").End(xlDown)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"skev" wrote in message
...

Hi,

I have a task schedule spreadsheet on which I want to place ONE
date/time picker control. I'm looking for some code that will assign
the first empty cell in a column as the picker's linked cell... any
ideas?

Thanks,
skev


--
skev
------------------------------------------------------------------------
skev's Profile:
http://www.excelforum.com/member.php...o&userid=35332
View this thread: http://www.excelforum.com/showthread...hreadid=551027