View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Link Michael Link is offline
external usenet poster
 
Posts: 12
Default 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?