Replace "A" with Chr(13) - no quotes
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Shane Gidley wrote:
This code looks great to remove every day characters, but the problem
I have and that a lot of others on the web seem to have but cannot
find answers to is how to remove a blank line at the end of the cell,
or ^p. I tried replacing the "A" with "^p" of course, but it didn't
work. Any ideas for this?