Selection.AutoFilter Field:=1, Criteria1:=Range("Cell1").Value

--
Regards,
Tom Ogilvy

haim rozent wrote in message
...

i want to build a macro that filters a word or expretion
which the user enters , for advance, to a cell named ,for example,
"cell1".
thanks for yor advice

rozent



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!