AutoFilter VBA Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that I think should hide the AutoFilter arrow in column E
only. It runs as follows:

Sub HideArrows()
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False

For Each c In Range(Cells(1, 1), Cells(1, i))
If c.Column = 5 Then
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
End If
Next

Application.ScreenUpdating = True
End Sub

When I run it, however, I keep getting a compile error, indicating that only
comments may appear after end sub, etc., and it highlights the very first
liine of the program. There are no other macros before this.

Help! I know virtually nothing about VBA, so probably I've made a very basic
error. Where did I go wrong?
 
You've got some kind of invisible characters in your code window.

Try highlighting the stuff to the right of "end sub" and all the way down.

Then hit the delete key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top