Good morning
I have an Excel file with 2 Sheets.
In the first (named CLAIM) it there is a list of codes in the coloumn A and other codes in the P-Q-R-S-T columns
In the other (named DELIVERY) it there is a list of codes in the coloumn A and the state of the order in coloumn CK
I must collate all the codes of the with the. P-Q-R-S-T of the CLAIM Sheet with the codes in coloumn A of the DELIVERY Sheet. If the codes are identical I control the string in the same row in coloumn CK; if the string is "Consegnato" the color of the cell in CLAIM Sheet must be green.
I have made two macros
1°) I have allotted the codes to of the variable and with For … Next cycles I compare codes
2°) I have used AutoFilter to compare codes
The two macro functions perfectly.
Problem
I launch first the macro n.1- time of execution= xTime
Then I launch the macro n.2- time of execution= yTime (very near to xTime)
Then I launch again the macro n.1- time of execution= xTime multiplied 7
Then I launch again the macro n.2- time of execution= yTime (around)
What caused this strange behavior?
Here is my file
Thank you in advance and there I pray of excuse my English
I wait for you reply.
Bye,
Mario
Bookmarks