Hi all

I've been working on 2 pieces of coding all weekend but seem to not get round it at all.

I'm trying to to show a message to the user when a value is >17 in any cell of a range (c7:g13).


I have the standard code:

if range ("c7") >17 then
MsgBox "one of the cells value is greater then 17" 
End if

i want it to look through my whole range (c7:g13) and if any cell has a value greater then 17 then show the message.

Can you help?



Also my second code i was looking for is similar, I'm doing a worksheet change event when columns 7 and 8 value = date and time on another sheet, to show an input box.


Please help, my hairs literally gone white thinking about this all weekend. I think i mjust being stupid and missing something obvious.

Thanks in advance.