Countif VBA Cell Value

[billandrew]

Good evening

Unable to find any specifics on utilizing the Countif Function referencing a specific cell. This example I'd like to count the number of instances which are below the entered value in A1.

Thanks all

    Dim lr2 As Long    lr2 = Range("C" & Sheet1.Rows.Count).End(xlUp).Row
    V1 = Cells(1, 1).Value
    
    Cells(1, 14).Value = Application.WorksheetFunction.CountIf("C2:C" & lr2, "<=" & V1)

 

[JoeMo]

Bad syntax. You need to specify the range object - like this:

Cells(1, 4).Value = Application.CountIf(Range("C2:C" & lr2), "<=" & V1)

 

[billandrew]

Story of my life.

Thank you very much...