View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Jason is offline
external usenet poster
 
Posts: 367
Default Advanced Filter VB Script for Variable Criteria Range

I'm new to scripting within Excel, and I am wondering if it is possible to
write a script for an Advanced Filter where the Criteria Range is itself a
variable. I would like to filter the data in a spreadsheet with the data in
a single column of another sheet. Since the amount of data in this column
can change from time to time and selecting the entire column incudling blank
cells below the data doesn't work, I want to have the filter adjust
accordingly. Example script:

Range (.Cells). AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Sheets ("Sheet1") .Range(VARIABLE RANGE HERE), Unique:=False

Thanks!