Not sure what you are doing, but there is no todaysdate function unless you
have a UDF with that name.

Maybe you meant =TODAY()


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 13:35:02 -0800, drinese18
wrote:

I want to basically update the date fields according to date, I tried putting
the function "=Todaysdate()" within my sheet but when my code tries to copy
it, it brings up an error. I want my dates on one sheet to copy from the
dates in another sheet on the same workbook, I could record a macro to do so
but I know once I do that it is just going to copy the same field over again,
I want it to copy the date that comes after the date i previously copied the
day before. So basically I would be coming in and then copying a date to that
other sheet day by day. Any help would be greatly appreciated, thank you