lolol I've just realized this is absolutely the most annoying thing that is not FIXED in Visual Basic. Not sure if everyone has experienced it at some point in time.

When you get a compile error on a line with "space$(something)"

Some people have said if they transfer all their files to a new project the error will go away, however for me, this was not good enough. My solution was easier , i just didn't think about it at first.

simply adding VBA.space$ solved it

anyone want to explain why this happens sometimes though? i think some people on the forum have had this problem with the space$ function and even right$