If then for POInv macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top