Why the integer stop loop even not reach the number? thanks!
Please help, I am trying to do until r > cases, the cases is 4000. which I can also confirm it on debug mode.
but if I run this code, the looping will stop when "r" reach "5". I tried to replace "r > cases" as "r > 9999", it works well.
just wondering what happens to cases....please help, thanks!
The code as below:
Formula:
Please Login or Register to view this content.
you could just use formulas for this its way faster
B5 =CONCATENATE("Male: ";COUNTIF(data!C:C;"M"))
C5 =CONCATENATE("Female: ";COUNTIF(data!C:C;"F"))
Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
If you have been helped, maybe you could click the *
could you modify this to VBA code for me? thanks!!Originally Posted by Joske920
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks