Hi all,
I am doing an example in order to get the gist of loops + functions. The file with code is enclosed.
My problem that the code executes ONLY the "Name" with the function COUNTA (where the surname does not exist)
(I do not understand why it does not take any data with that function apart the "Name") - separetely this function works in excel and counts correctly.
Hi Daria,
When I tried to open your file Excel told me that the VBA project and macros were corrupted.
Can you please attach another copy of the file.
Regards
Phil
Hi, Philip.
It is really weird as i download the attached file and opened it without any issue. By the way, see enclosed file again.
Thank you.
It was corrupted for me to, i wonder if it is becuase of the languge it was created in?
What are you trying to do, loop through the LIST_WRONG sheet and make it in to LIST_CRR?