| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter run time error 400
Hello! When I run the code below, I can see the first row being selected and
the autofilter being turned on. However, I'm getting a run time error 400. Any ideas? 'Set autofilter on If Not oSheet.AutoFilterMode Then oSheet.Rows("1:1").Select Selection.AutoFilter = True End If Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter run time error 400
Dear Radon
'Selection.AutoFilter' is enough If this post helps click Yes --------------- Jacob Skaria "Radon" wrote: Hello! When I run the code below, I can see the first row being selected and the autofilter being turned on. However, I'm getting a run time error 400. Any ideas? 'Set autofilter on If Not oSheet.AutoFilterMode Then oSheet.Rows("1:1").Select Selection.AutoFilter = True End If Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 91 in Autofilter | Excel Programming | |||
| Excel Autofilter Error | Excel Discussion (Misc queries) | |||
| Excel Autofilter error | Excel Discussion (Misc queries) | |||
| Autofilter rows and columns at the same time | Excel Programming | |||
| Copy error with Autofilter | Excel Programming | |||
Linear Mode
