reference cell values in VBA

[briankimberly]

how do I reference value of a cell in VBA example..

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveSheet.Range("$A$1:$XFD$10000").AutoFilter Field:=2, Criteria1:= _
"NAME"

I want to replace hard coded "NAME" with the contents of a cell in another sheet?

 

[Norie]

Something like this perhaps.

ActiveSheet.Range("$A$1:$XFD$10000").AutoFilter Field:=2, Criteria1:= _
 Sheets("Sheet2").Range("A1").Value

 

[briankimberly]

perfect! thx!