"Compile error: Sub or Function not defined" Not sure how to fix

[Figritout]

Sub EditFile()
' Unhide Row 1
Rows("1:1").Hidden = False

' Expand Column B to a width of 29.00
Columns("B:B").ColumnWidth = 29

' Unfreeze Panels
ActiveWindow.FreezePanes = False

' Delete Rows 1 through 8
Rows("1:8").Delete

' Delete Column A
Column("A:A").Delete

' Delete Columns C, D, E
Columns("C:E").Delete

' Delete Columns G, H, I, J, K, L, M
Columns("G:M").Delete
End Sub


Is what I have entered and it is to auto edit a file for me after I add it to a workbook. I only want one of the sheets edited and This is the error I keep getting.

 

[Joe4]

Welcome to the Board!

This line:

Column("A:A").Delete

should be this:

Columns("A:A").Delete

Note: If you try compiling the code, it shows the error and takes you right to the offending line!

 

[Figritout]

Thank you!! I'll correct this, but it specifically pointed out the "Sub EditFile()" line as well. Would this need to change too?

 

[Joe4]

Thank you!! I'll correct this, but it specifically pointed out the "Sub EditFile()" line as well. Would this need to change too?

Try making the fix I suggested and see if you still have any issues.
If you do, I suspect it will be a different error message.

 

[Figritout]

Thank you so much, that was the fix I needed! This is my first time doing anything like this so I appreciate the assist. Next on the list is creating a button to automate adding formulas with a new sheet sheet name as they are added to my workbook.

 

[Joe4]

Thank you so much, that was the fix I needed! This is my first time doing anything like this so I appreciate the assist. Next on the list is creating a button to automate adding formulas with a new sheet sheet name as they are added to my workbook.

Excellent! Glad I was able to help!

You can post your new question to a new thread. It is best to do that so that it appears as a new unanswered question on the "Unanswered threads" list that many people use to look for unanswered questions to respond to.