Macro to Autofilter

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Hi,

I have a spreadsheet that has number of coloums
A = Name
B = Address
C = Process

I have a userform that has Macros's on it. I am trying to
create a macro that is called 'Glenn' and when pushed it
will take the user to that spreadsheet (Sheet2) and
autofilter coloumn A and display cells that equal Glenn.

Many Thanks
 
Glenn,

You could have gotten this with the macro recorder. My solution hardly seems
worth a macro <VBG>

Sub Glenn()
Worksheets("Sheet2").Columns("A:A").AutoFilter Field:=1,
Criteria1:="Glenn"
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top