Hi
how Using the function "countifs" in VBA ?
Printable View
Hi
how Using the function "countifs" in VBA ?
You need to be a bit more specific than that.
I found myself
Code:TextBox5.Text = WorksheetFunction.CountIfs(Sheet1.Range("b:b"), TextBox2.Text, Sheet1.Range("f:f"), (">=" & TextBox3.Text), Sheet1.Range("f:f"), ("<=" & TextBox6.Text))
Are you able to post a sample workbook showing what it is that you are trying to do? I am unable to follow what you are trying to explain at this point.