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)

"Glenn" wrote in message
...
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