Please see the enclosed workbook.
I have made a macro to ease finding todays date, but the respons is 'Date not found'.
Could somebody look into the macro and find the error... ?
Saturn
Please see the enclosed workbook.
I have made a macro to ease finding todays date, but the respons is 'Date not found'.
Could somebody look into the macro and find the error... ?
Saturn
Last edited by Saturn; 12-12-2011 at 03:06 PM.
try this way:
but better wilL be this:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by tom1977; 12-09-2011 at 10:40 AM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Thanks tom1977
It seems that the macro is cell-format-sencitive.
Your macro works fine with the cell-format in the example, which is *14.03.2001 Norwegian (Bokmål).
I still get the respons Date not found for this format: 14-Mar-2001 English (U.S.)
How do I come around this problem ?
Please Login or Register to view this content.
???
Where is this code to be put in?
Still not working.
Still I have not find a solution to this problem.
The original document is ammended with regard to the cell-format of the date-column.
The Date format is 14-Mar-2001 English (U.S.)
Still the error to the macro is Date not found
try to replace your code in GoToToday() with the snb's code.
it works for me.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Can you give me the entire code ?
It doesn't work for me.
I used the same code
Please Login or Register to view this content.
This doesn't work for me.
Could someone give me the entire code?
hi,
try this and see if it helps you
Please Login or Register to view this content.
This should work:
Please Login or Register to view this content.
_______________________________________________
Remember:
Read the rules!
Use code tags! Place [CODE] before the first line of code and [/CODE] after the last line of code.
Mark your post [SOLVED] if it has been answered satisfactorily.
To do this, click EDIT in your original post, click GO ADVANCED and set the PREFIX. It helps everybody!
If you are approve (or disapprove) of any members response to your problem, please click the icon underneath their post and comment. It matters.
Thanks wamp
Your code is working.
I think this was a matter of problem with the cell formatting of the column containing the dates, and your sugesting is working.
Also thanks to john55, but for this one I got the annoing ‘Date not find’.
Saturn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks