When you pasted that macro into the VBA editor, were some of the lines
colored red? That's the editor's way of telling you those lines have a
problem.
In this case, the red lines end with an underscore character, which is
supposed to mean that the next line is part of the same statement. However,
because of the formatting on the web page, the pasted text has an extra
blank line after each line of text, and the underscore doesn't have anything
on the "next line" to complete the statement. Just delete the blank line
after each line of red text. When it all turns to black (and green for
comments), try running it.
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
