I cannot do space in my VBA code

Question

Hi All! :)

I have a strange issue. I cannot do space when I write my VBA code. It works everywhere else - in browser, excel workbook, outlook etc. What's more, I can do space to separate existing string. So I can type "Anexampleofsentence" and then divide it to "An example of sentence", but I cannot do that by typing word after word. I tried to restart my PC, but it didn't work.

I hope someone here can help me :)

Answer 1

Problem solved. The issue occurred only when I opened original file from sharepoint, it doesn't happen when I save it to my local disk. I will simply replace the file with another one.