Excel VBA: Getting rid of spaces from code copied from the internet

Question

Hello,

Lately when I paste code from the internet (various sites) to Excel VBA module, the body of the code will be red text, and if I try to run it it will say Compile Error: Syntax Error. I have to manually remove the spaces at the beginning and end of each line of code and in between lines of code for it to run.

Why is this happening so often lately and what is a quick way to remove the unwanted spaces described above? 

Thank you for your help.

Here is a picture:

Answer 1

Hi KC_C,

Your problem is due to the presence of non-breaking space characters (Ascii 160).

To remove them from your code:

• Select the code
• Ctrl+H to open the Find\Replace dialog
• In the Find box,, with the Alt key depressed, type 0160 using the numeric keypad
• In the replace Box, delete any text
• Replace all
• OK

===

Regards,

Norman

Answer 2

Thank you, Norman. That sold the problem. God bless you.

Answer 3

Hi KC_C,

Thank you, Norman. That sold the problem. God bless you.

Thank you for your kind feedback and I am glad that you have resolved the problem. 

===

Regards,

Norman

Answer 4

Hi,

You may refer to my solution here.

Hope this helps.

Answer 5

Hi,

You may refer to my solution here.

Hope this helps.

Thank you.