View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jimmy Jimmy is offline
external usenet poster
 
Posts: 22
Default Auto Filter Problem

To those that see my code below...It creates an auto filter. When I
click down on the drop down, I get a graphic of a hand/finger pointer,
which does nothing. Any ideas as to what is happening here?

Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"),
DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(12, 1), Array(34, 1),
Array(47, 1), Array(59, 3)) _
, TrailingMinusNumbers:=True
Cells.Select
Selection.Columns.AutoFit
Selection.AutoFilter
Range("A2").Select
ActiveWindow.FreezePanes = True
Range("A1").Select



In advance, thank you for your generous time and attention,
JR