Advance Filter critera range

[Dwight Trumbower]

When using the CriteriaRange do you have to point to a range or can you have
a variable with the correct format?

From the examples it looks you need to point to a range. Either a column
name, value combination or a range formula.

What I'm trying to do is take a spreadsheet that has four distinct values in
column 3 and filtercopy on each value into a new sheet. The data range is
105 columns and many rows with now headings. I create a tmp sheet with
unique values from column 3 and then try to create a range formula, =c1="F".
It seems silly that I can't use this in the criteriaRange:=. I'm sure I'm
doing something wrong.

Thanks

 

[Tom Ogilvy]

The criteria must be a range.

 

[Dwight Trumbower]

When do the following: tmpSheet.Range("B1").Value = "=C9" & Chr(34) & "=" &
myCell.Value & Chr(34)
I get false for the value instead of =C9="F". myCell.Value = F


Dwight