Countif code returning "TRUE" instead of a value

[tchaik1812]

I'm looking to use a countif function on a selection of cells. My code is:

Range("A2").Formula = "=COUNTIF(& Selection.Address &, " >= "&B3)"

and it returns "True" after I run the macro, when I want the actual count. (Let's assume D7:D184 is my selection address, and B3 contains the criteria value) I can type:

=COUNTIF(D7:D184, ">="&B3)

into the Excel spreadsheet, and it returns the actual count. What am I not understanding, and how can I make my VBA code return an integer instead of "TRUE"?

I appreciate the help.

[benishiryo]

welcome to the forum, tchaik1812. try:

Range("A2").Formula = "=COUNTIF(" & Selection.Address & ", "">=""&B3)"

the whole formula there is a text. so you have to separate the formula & the variable (Selection.Address). the double quotes have to be doubled ("">="") when you use it as a formula in VBA. otherwise, it will think that you're ending the code.

[tchaik1812]

benishiryo,

Thank you so much. I've been struggling with this for hours. Since I posted the thread, I realized I needed the double quotes around the >= portion of the code, but wasn't putting quotation marks around & Selection.Address &.

Thanks again.