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:
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.
Bookmarks