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