I have coded a spreadsheet wherein the user enters data through InputBoxes. It's looped to repeat as many times as necessary. The data is an array in memory. I now need to do a CountIf for one of the values within the array that meets 2 criteria. I have tried the following two ways, neither work.
Object Error:
rcount = WorksheetFunction.countif(revcode(i), "<=359") And WorksheetFunction.countif(revcode(i), ">=320")
AND
Doesn't recognize the "range"
rcount = WorksheetFunction.countif("B13:B" & (iCountBoxER + 13), "<=359") And WorksheetFunction.countif("B13:B" & (iCountBoxER + 13), ">=320")
Bookmarks