Macro Not Running: Compile Error

[poorwallace]

Hello All,

This is probably a pretty easy question, but I'm having problems stepping into or running a macro from the VBE. When I hit F8 to step through it or the run button, I just get a "Compile Error: Expected Expression".

I must note, though, that the macro runs fine if I run it by hitting ALT+F8 in normal Excel mode and then hit the run button.

I'm curious to find out why this is happening...

Any assistance would be greatly appreciated!

 

[Tazguy37]

Got code to post?

And what version of Excel are you using?

 

[Mooresmi]

Put your code up so that we can see it.

 

[poorwallace]

Sure, below is the code. I'm running Excel 2003. And, yes, there are values in both column N (14) and C (3)

I'm curious to see what's going on here...

Sub Name()

Dim RNG1 As Long
RNG1 = Cells(Rows.Count, 14).End(xlUp).Row
Dim Fname As Integer


For Each Cell In Range(Cells(1, 14), Cells(RNG1, 14))
    
    If Cell = "Yes" Then
    
    
    Fname = Cell.Offset(0, -11).Value
    ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
    ActiveSheet.Name = Fname
    
    End If

Next

End Sub

 

[Tazguy37]

You can't use Name as the name of a Sub.

 

[poorwallace]

That was it! though I find it strange that I could still run the macro with ALT + F8 and hitting the "Run" button...

Thanks!

 

[Tazguy37]

I thought that was weird myself, but as soon as I changed the name of the sub, everything was fine.