Error 2042 while comparing dates

It is going to be difficult for us to help debug this with only the code to work with. Can you upload a sample file?

Error 2042 is the #N/A error returned when Match() does not find a match. I see two possible meanings to fixing this error.

Do you mean that you need help with error trapping the error so that your procedure will know what to do when match does not find a match? If this is what you mean, then your procedure needs an additional If..End If block that will deal with the error.

Or do you mean that you are certain that it should find a match, and you are trying to figure out why it is not finding a match? If this is what you mean, then you will need to look very carefully (using watches or the immediate window or other debugging tool ) to see exactly what is in slItem.Name and what is in column A of sheet "30days" and make absolutely sure that they are the same. If you are unfamiliar with VBA's debugging tools: http://www.cpearson.com/excel/DebuggingVBA.aspx

Issue here is that A1 is also =TEXT()

So when you are adding to A1 column B values, depending on region setting it will return #Value Error.

In A1, have valid date value, and format as dd-mm-yyyy.

Also, to avoid updating PivotTable during every iteration of loop, code modified to below.

Please Login or Register  to view this content.

See attached.

Though personally, I'd recommend utilizing OLAP based Pivot Table.

You are welcome and thank for the rep

If your query is answered. Please mark the thread as solved using thread tool found at top of your initial post.