Error after date: 10-10-2021

Hello,

I wrote and starting using the code at the start of 2021. Somewere around 2-2021. It worked perfect until two weeks ago. I think it has something to do with the date value, for it does not work after 09-10-2021.
the code works as follows:
I enter a date in B3 sheet AFVAL_TOT. In sheet AFVAL_DATA is a list ranging from 1-1-2021 to 31-12-2021. when i press the button (which starts the code) it will take the values from worksheet AFVAL_TOT and copy it to worksheet AFVAL_DATA in the list with dates behind the date thats corresponds with the date from B3.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here I have done it for you this time.)

There is no 360 version of Excel - you have 365. Update your forum profile, please. Thanks.

Hello and welcome

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Following Ali's note, although you had added code tags the layout of the underlying code was not indented.

It's always advised to do this to make code easier to read.

Following Ali's note, although you had added code tags the layout of the underlying code was not indented.

Your edit has made no difference, Richard: I had added the code tags. The OP did not, and that's why I posted the admin note and amended his/her opening post.

@ m gruwel

PLEASE update your forum profile to MS365 - 360 is not correct(that's degrees in a circle, not days in a year).

For the avoidance of doubt I didn't edit anything. Once I opened the post and saw there were no indenting characters in the original I simply pressed save rather than just back out.

Ah, OK - that makes sense. However, by saving, you have date-stamped the post as having been amended by you. You can just cancel the edit to avoid this happening.

Seems to work OK for me.

Of course the date 01/01/2022 in D285 is not consistent with the other dates in column D, hence if your question is why doesn't 11/10/2021 in D3 work that's because there is no such date in the Data sheet.

well, i think i forgot the change the date back to 01/01/2021. I changed it while error solving. I forgot to change it back. but is does not solve the problem. the dates 10-10-2021 till 31-12-2021 seems to be the problem. The dates 1-1-2021 till 9-10-2021 seem to work fine. I added the Excel file with the right date.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new, I will do it for you today: https://www.mrexcel.com/board/thread...-2021.1185674/)

TWO rules broken already - time to read the rules: https://www.excelforum.com/forum-rul...rum-rules.html

@m gruwel

It is obvious that you have not bothered to read the forum rules you agreed to when you joined this forum. Please do so now and abide by them in the future.

crossposted: https://www.mrexcel.com/board/thread...-2021.1185674/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

You have asked for this thread to be closed so you can start another on the same issue. Sorry, this will not happen.

Continue here, please. Thanks.

Dates later than 10/10/2021 work fine for me.

Please restate your problem.

I also see that it doesn't find dates very well, (I hate Excel and dates)

Try modifying to:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Thanks Ali for reminding about the thanks option, and more importantly the mark as complete

I've edited this to remove negativity.