If then for POInv macro

[Guest]

i have a macro that works when you press a big button (saves a copy on the
hard drive, emails out a copy, prints out a copy, cleans the purchase order
so it's blank, increases the counter, then saves it again.)

i want an if / then statement so that it will only work if the value in cell
M7(the date) <> "[Ctrl] ;]" - i want them to use [Ctrl] ; so that they have
entered the correct date

i have tried the following at the very begining of the macro:
If .Range("M7") <> "[Ctrl] ;" Then
w/ end If at the very end of the macro.

it will not work. can that statement work, or is there another sub date
macro that can be used to enter the current date when the macro is run?


regards,

jat

 

[Roger Govier]

see reply to your later posting