VBA Autofilter call not working

[sflowers]

I am having the most ridiculous problem, but I cannot get a VBA autofilter call to work to save my life! I can manually execute the filter in question, but when I run the following

Sub LocationFilter()
MsgBox (ActiveSheet.Name)

ActiveSheet.Range("A:M").AutoFilter Field:=2, Criteria1:="802"

End Sub


absolutely nothing happens. Sheet is unprotected, data format is general......Any suggestions?

[MarvinP]

Hi sflowers and welcome to the forum,

Turn on the macro recorder and do the steps you want to happen.

Look at the VBA code to see what it did. The recorded code and what you have should show you the way.

[sflowers]

did that, does not work, in fact I can remove the filter and run the just written code and nothing happens

[sflowers]

So for an overview, I just recorded the following with the autorecord feature

Sub Macro2()
'
' Macro2 Macro
'
'
ActiveSheet.Range("$A$1:$O$136267").AutoFilter Field:=4, Criteria1:="7"
End Sub

I then cleared the filter on the sheet and re-executed the macro, nothing happened. WTF?

[pike]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

and

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[MarvinP]

I guess I need a sample file to see what I'm missing in this question.

You can attach a sample by clicking on "Go Advanced" and then the Paper Clip Icon.

[Trebor76]

For reference cross posted (also without tags) here

[sflowers]

For any future users, I was missing a line of code in order to engage the filter (when I recorded macro filter was already in place)

Selection.Autofilter