Revolvr,

I have copied and pasted to Word, Excel, NotePad, etc. It's like any other
copy and paste. The only problem I have encountered is copying from an
Excel worksheet and pasting into one of these posts - for some reason the
font comes out small.

Unfortunately - when you paste it back into a code module you may have a few
minor problems:
The color formating won't carry into the module.
Sometimes the paste carries spaces that Excel doesn't like and comes up
with an error. You'll need to compile your code to avoid this. I see
this
mostly when copying code from the forum and pasting it into a module.

But pasting into Word is a great way to document and store code.
I have a special Excel workbook (worksheets) filled with code (for
reference). Now I have a central source to help write code.

--
sb
"Revolvr" wrote in message
news:YXK3b.9443$QT5.1344@fed1read02...
Printed VBA code is harder to read than on-screen. I would like to copy
and
paste the code into Word then format it to be more readable, including for
example:
* Changing font to Courier
* Change color of comments
* Bold Subroutine/Function and end Sub/Function lines
* Other?

Has anyone created Word macros to improve the formatting/readability of
printed VBA code?

TIA

-- Rev