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
Gord Dibben - 25 Jan 2008 22:14 GMT
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
>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
[quoted text clipped - 4 lines]
>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