Copies From The Internet
Paste Values means nothing when you are not copying from Excel. If the
webpage is not set up properly, you will always need to reformat and
possibly delete some characters (like non-breaking spaces) before
being able to use the data properly. If the copy job is frequently
done, I find it easiest to put all the steps into a macro and run it
after pasting.
|