VBA - How to select autofilter range in an yet unnamed workbook?

  • Thread starter Thread starter Frank Krogh
  • Start date Start date
F

Frank Krogh

I try to select an autofilter range in a yet unnamed workbook (BookX):

If Not Selection.AutoFilter Then Selection.AutoFilter
Workbooks(Workbooks.Count).Activate
Workbooks(Workbooks.Count).Application.AutoFilter.Range.Select


Why do I receive the error message 438 "Object doesn't support this property
or method"


Thanks for suggestions


Frank Krogh
 
Sorry, this seems to works better :-)

If Not Selection.AutoFilter Then Selection.AutoFilter
With ActiveSheet
.AutoFilter.Range.Select
End With
 
Workbooks(Workbooks.Count).Activate
If Not ActiveSheet.AutoFilterMode Then Selection.AutoFilter
Activesheet.AutoFilter.Range.Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change date format in VBA 8
Copy Autofilter Source Workbook A result in Destination Workbook BSheet1 1
AutoFilter 2
VBA to VB6 6
Trying to insert rows in a Macro 5
How to Select A Cell in VBA with a Variable Row Number? 3
Using Autofilter within a macro 3
resetting the autofilter for users of a workbook 4

Back
Top