Vba adds unwanted space

[reparsa]

Hello!

Im new to VBA and I would be really grateful if anyone could solve my issue.

The other day I wrote this code:

Please Login or Register  to view this content.

It worked perfectly, I saved it and closed. Today I opened it up and the code suddenly stopped working.
The only difference I could see was that VBA automatically added a space in the end between Range(Here)("A1"), so it looke like this

Please Login or Register  to view this content.

And I cant remove the space, could any kind soul tell me why excel suddenly added a space and how I can fix it?

[6StringJazzer]

The line of code causes a runtime error and probably isn't what you actually want to do. What cell are you trying to reference with that line of code?

[jindon]

Please Login or Register  to view this content.

It worked perfectly

I can hardly believe it worked.
Sheet object doesn't have End property.
It should be something like

Please Login or Register  to view this content.

or in one line

Please Login or Register  to view this content.

.Range("A1") in red and bold is not needed.