Skip to content

Instantly share code, notes, and snippets.

@agbishara
Created April 15, 2014 15:51
Show Gist options
  • Select an option

  • Save agbishara/10743279 to your computer and use it in GitHub Desktop.

Select an option

Save agbishara/10743279 to your computer and use it in GitHub Desktop.
This Filters a range of data by a string, its setup for a specific usage
Public Function fitlerBySVP(Name As String, ws As Worksheet)
ws.Range("$A$1:$F$38409").AutoFilter Field:=4, Criteria1:= _
Name
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment