Per the macro below, how do we select the cell value and not the number value
currently in the cell? That is, we don't want it to select "2871". We want it
to select what is in cell A1. If it happens to be 2871, great. If not, we
want it to display whatever number is there.


Range("C7").Select
Selection.Copy
ActiveSheet.Next.Select
Selection.AutoFilter Field:=1, Criteria1:="2871", Operator:=xlAnd
Range("A1").Select
End Sub