|What is wrong with using a formula? The formula I offered will continually update immediately based on the data in the range and not be dependent on a macro being run to update the cell.|
As far as: "I have other macros which I also run for other single values and need another to include this range"...I'm once again confused.
Why not just add the test for these values to your existing macro instead of adding another one for this single task?
In any case, this code should do what you are asking for. It is just one of many, many ways to accomplish the goal of putting the message in F151 based on the values in the range.
Note: The code assumes Sheet(1), modify as required.
If Application.WorksheetFunction.CountIfs _
(Sheets(1).Range("D2:D151"), ">0", Sheets(1).Range("D2:D151"), "<8") _
Sheets(1).Range("F151") = "No Jackpot This Week"
Else: Sheets(1).Range("F151") = ""
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03