November 19, 2008 01:18am pst

1. GrahamSkan 489,054
2. matthews... 388,582
3. PaulHews 327,834
4. RobSamp... 319,732
5. zorvek 310,350
6. jpaulino 283,226
7. Idle_Mind 240,019
8. angelIII 197,709
9. rorya 196,990
10. danaseaman 171,880
11. BlueDevilF... 166,975
12. c0ldfyr3 157,345
13. capricorn1 128,322
14. saurabh726 116,195
15. webtubbs 114,001
16. robinu 112,221
17. TRobinJa... 109,490
18. robberbaron 97,170
19. emoreau 96,058
20. Dhaest 86,719
21. purplepo... 85,982
22. nutsch 83,701
23. chris_bot... 83,347
24. byundt 83,235
25. ee_rlee 81,307

1. Idle_Mind 1,866,555
2. GrahamSkan 1,526,909
3. PaulHews 1,460,773
4. AzraSound 1,400,747
5. angelIII 1,294,935
6. vinnyd79 1,242,790
7. Erick37 1,211,724
8. EDDYKT 1,143,342
9. emoreau 1,120,917
10. matthews... 1,025,038
11. TimCottee 1,010,616
12. BlueDevilF... 905,552
13. ryancys 868,939
14. Ark 856,902
15. egl1044 752,746
16. Shauli 718,021
17. sirbounty 669,716
18. zorvek 628,113
19. zzzzzooc 552,977
20. inthedark 529,097
21. Richie_Si... 508,332
22. RobSamp... 502,917
23. rorya 484,765
24. danaseaman 476,189
25. Dhaest 465,652

08.07.2008 at 02:45PM PDT, ID: 23631135

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.1

Proper syntax fir COUNTIF function in vba script

Asked by ilrosebud26 in Visual Basic Programming, Microsoft Excel Spreadsheet Software

What is the proper syntax for using the COUNTIF function in vba? I have both my current row and last row defined as below in the below code snippet. I have tried but do not know what I am doing wrong. I need to take action if the current row value is duplicated in column b.

I have tried:
If Application.WorksheetFunction.CountIf(rng, currentrow & "B") > 1 Then

and

If Application.WorksheetFunction.CountIf(rng, "B" & currentrow) > 1 Then

but the macro does not find a duplicate.

I have also attached my test file.

Start Free Trial

         
             Dim currentrow As Integer
Dim lastrow As Integer
Dim rng As Range
 
currentrow = 1
lastrow = Range("B" & Cells.Rows.Count).End(xlUp).Row
Set rng = Range("B1:B8")

Attachments:

testing.xls (23 KB) (File Type Details)

My little test file

Keywords: Proper syntax fir COUNTIF function in v…

	Title
1	COUNTIF
2	COUNTIFS
3	Countif with "OR"
4	Countif Help
5	Countif on a Autofilter
6	Using VBA to insert a countif function

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Proper syntax fir COUNTIF function in vba script

Asked by ilrosebud26 in Visual Basic Programming, Microsoft Excel Spreadsheet Software

About this solution