Quotes

[billandrew]

Afternoon

Can someone assist with the correct syntax for the below countif

cell(1,12).formula ="=countif(G1:G100),"<=10000")

 

[Rick Rothstein]

Afternoon

Can someone assist with the correct syntax for the below countif

cell(1,12).formula ="=countif(G1:G100),"<=10000")

Internal quotes must be doubled up otherwise VB cannot tell if they are internal as opposed to those delineating the end of a quoted text string. You also incorrectly used "cell" instead of "cells", plus your formula had an out of place parentheses. Try it this way...

cell(1,12).formula ="=countif(G1:G100),""<=10000"")"

 

[Trebor76]

Hi billandrew,

Try this:

Range("L1").Formula = "=COUNTIF(G1:G100,""<=""&10000)"

Regards,

Robert

 

[billandrew]

@Mr.Rothstein

I did utilize the cells property Typo. Adjusted your script with the below Quotations. Thank You!

Cells(1, 12).Formula = "=countif(G1:G100,""<=""&10000)"

@Tebor76

The Script provided worked well.

Thank You as well.

Happy New Year All