I'm looking for a function to count the number of times the cell A2 in Sheet7 occurs in the A column of sheet9. This does not work:
NumFu = Application.CountIf(Sheet9.Range("A:A"), Sheet7.Range("A2").Text)
Any ideas?
Thanks in advance
I'm looking for a function to count the number of times the cell A2 in Sheet7 occurs in the A column of sheet9. This does not work:
NumFu = Application.CountIf(Sheet9.Range("A:A"), Sheet7.Range("A2").Text)
Any ideas?
Thanks in advance
Last edited by HalPlz; 06-22-2015 at 12:47 AM.
What is the value in Sheet7!A2? is it a date?
Im not sure why, but using the .Text property is giving inconsistent results, .Value is better
NumFu = Application.CountIf(Sheet9.Range("A:A"), Sheet7.Range("A2").Value)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Instead ofusePlease Login or Register to view this content.
Instead ofPlease Login or Register to view this content.
you need to usePlease Login or Register to view this content.
Cheers!!Please Login or Register to view this content.
Last edited by JBeaucaire; 06-28-2015 at 02:52 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks