AutoFilter VBA Problem
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?
|