Thread: help with macro
View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1853_] Rick Rothstein \(MVP - VB\)[_1853_] is offline
external usenet poster
 
Posts: 1
Default 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