Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Another Excel Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
drinese18 - 25 Jan 2008 21:35 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.