Unexpected Compile Error

[mialls]

Error: Compile Error - Expected Function or variable

Macro:

Sub WhiteFlag()

Range("A5").Select
Selection.EntireRow.Insert
​

End Sub

(The word "Selection" is highlighed in the VBA editor, hence why it is highlighted here.)


This macro worked perfectly until about an hour ago, as part of a larger macro. I tried rewriting it by hand, then separating it into its own individual macro, and finally I used the Record Macro tool, all with the same result.

The exact same Macro in an entirely new Excel file works perfectly.

Any idea's what I did to cause this and how to avoid this in the future?

 

[RoryA]

Do you have a variable, sub, function or module called Selection?

 

[mialls]

Ha. That fixed the problem, and I learned something new.

I do have a Sub named "Selection" it seems - two, in fact. (Well, the same macro in multiple locations.) First in an actual Module, and second in code for a UserForm. The Macro in the Userform code section wouldn't run properly (it would only open the Userform when I tried to run it), but it wasn't impeding any other code from running, even when the Userform was being tested.

Once I cleaned up the code section of the Userform, and copied all the code that wasn't working to a Module for investigation and testing later, that's when the problem came up.

Thanks!