LinkBack URL
About LinkBacks
hi there,
I'm testing out a VBA using application.worksheetfunction.countifs()
When i hit the button, i keep getting 0.
Please Login or Register to view this content.
any ideas?
I'm using excel 2010
thank you
hi there,
I'm testing out a VBA using application.worksheetfunction.countifs()
When i hit the button, i keep getting 0.Please Login or Register to view this content.
any ideas?
I'm using excel 2010
thank you
Last edited by Lifeseeker; 02-02-2012 at 01:26 PM.
Hi Lifeseeker,
See if this isn't what you really want.
Your code above only showed the result for the last row, which was zero.Please Login or Register to view this content.
Read http://www.cpearson.com/excel/Debug.htm to learn how to figure these out for yourself. I set a breakpoint in your code and stepped through it line by line. I could also have set an "Add Watch" to the variable result to see how it changed with each loop.
Last edited by MarvinP; 02-02-2012 at 12:58 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Have you checked that actually entering a formual like that on your worksheet produces a result?, i suspect it doesn't, have a go
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Last edited by Simon Lloyd; 02-02-2012 at 12:56 PM.
Doh!, totally missed that
Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13
Nice!,
thank you.
The result was only showing the last row as I didn't really have the
[code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks