View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ernie Ernie is offline
external usenet poster
 
Posts: 65
Default need help "worksheet_activate( )"

i need help using the autofilter function in my worksheet activate event
procedure
i'm using these parameters below:

Private Sub worksheet_activate()
Range("A1:C1").AutoFilter 2, "<", , , False
End Sub

i want the worksheet to autofilter automatically when i select the sheet.
i'm still getting errors i need help. can anyone help me with these codes??

thanks in Advance
--