help with macro
What do you disagree with precisely
Your message said this...
Change:
"Other Shifts " _
& Format(Now, "dd-mmm-yy") '<<==== CHANGE
to
Format(Now, "dd-mmm-yy")
The only difference I see is in what you posted as the change was the
removal of the ampersand (the Format statements appear to be identical), so
I assumed you were "correcting" what you thought was a "extra" ampersand on
the line. My response was saying that the ampersand is necessary because of
the line continuation character.
Rick
|