VBA Count number of times value appears in a column. With column as integer

[uk747]

Wanting to count number of times a value appears in a column, however my variable is the column number not letter

So instead of counting values in range D:D it will be 4:4 although 4:4 is used for rows

I need to count if number of times ABC appears more than 3 times in column D but using the variable of 4

I used the variable as the column often changes

 

[Andrew Fergus]

Hello
There is quite a bit to unpick here.
1. What have you tried so far?
2. Must this be in VBA? Or will a formula do the job?
3. And, what happens next? Will that value be written to a sheet? Or used in another routine?

 

[Peter_SSs]

Something like this?

Sub Use_Col_number()
  Dim ColNum As Long
  
  ColNum = 4
  MsgBox WorksheetFunction.CountIf(Columns(ColNum), "ABC")
End Sub

 

[uk747]

Something like this?

Sub Use_Col_number()
  Dim ColNum As Long
 
  ColNum = 4
  MsgBox WorksheetFunction.CountIf(Columns(ColNum), "ABC")
End Sub

Yes, just needed to count the values in the column variable which I'd used VBA to get

Thanks Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.