ok T = Application.WorksheetFunction.CountIf(Range("g15:g 27"), "<6")
works, any ideas how i can use a variable in place of "<6". Ive tried T
= Application.WorksheetFunction.CountIf(Range("g15:g 27"), < point), but
get an error. Also I want to replace the range with selected cells.
T = Application.WorksheetFunction.CountIf(Active.cells ,< point).
Regards Robert