Forum

Do Until Loop (LOOP...
 
Notifications
Clear all

Do Until Loop (LOOPS)

4 Posts
3 Users
0 Reactions
132 Views
(@berliony)
Posts: 4
Active Member
Topic starter
 

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.

 
Posted : 06/10/2020 1:50 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

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

 
Posted : 06/10/2020 4:48 am
(@berliony)
Posts: 4
Active Member
Topic starter
 

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.

 
Posted : 11/10/2020 1:19 am
(@purfleet)
Posts: 412
Reputable Member
 

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?

 
Posted : 11/10/2020 3:50 pm
Share: