Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
autofilter problem | New Users to Excel | |||
Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
Excel AutoFilter Problem | Excel Discussion (Misc queries) | |||
Autofilter problem | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |