WorksheetFunction.CountA not working

**timtim89** · 04-02-2012, 06:17 AM

Hey there,

What I try to do is following: When the macro is run, I wish to exit the macro if countA(C:C)>countA(D:D) and otherwise continue.. Following code is for some reason not counting right the number of cells with values, cause it reaches the "Else" part every time, even thought c > d. Tried a couple of stuff to avoid the problem, but didn't succeed. Does anyone know what Im doing wrong? Thanks a lot!

Please Login or Register  to view this content.

**davesexcel** · 04-02-2012, 07:27 AM

You never gave the range to count.

Please Login or Register  to view this content.

this will get the same results

Please Login or Register  to view this content.

**timtim89** · 04-02-2012, 07:53 AM

Aha that makes sense. Work great now

thanks

**Excel4444** · 04-12-2021, 10:34 PM

trying to get the below to work and seems to be acting up.

Please Login or Register  to view this content.

thanks in advance!

**FDibbins** · 04-12-2021, 11:28 PM

Originally Posted by Excel4444

trying to get the below to work and seems to be acting up.

Please Login or Register  to view this content.

thanks in advance!

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread