Hi, mubashar,
maybe like this avoiding a loop:
Ciao,![]()
With WorksheetFunction MsgBox .CountIf(Range("M:M"), ">149") - .CountIf(Range("M:M"), ">201") End With
Holger
Hi, mubashar,
maybe like this avoiding a loop:
Ciao,![]()
With WorksheetFunction MsgBox .CountIf(Range("M:M"), ">149") - .CountIf(Range("M:M"), ">201") End With
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks