How to reference the value in a cell (text value) ?

[Vexorg]

Hi,

I have a dynamic cell G5 (on Sheet1). The value in the cell changes when I selected different items in a list box.

How do I reference the cells value in the below (marked in Red):

Rows("1:1").Select
Range("AZ1").Activate
Selection.AutoFilter
Sheets("3rd Party and Phones").Range("$A$1:$BK$19814").AutoFilter Field:=55, Criteria1:= _
"I need the value here from G5 Sheet1"

 

[Desu Nota from Columbus]

Criteria1=Worksheets("Sheet1").Range("G5").Value

 

[Andrew Poulsom]

Like this?

Sheets("3rd Party and Phones").Range("$A$1:$BK$19814").AutoFilter Field:=55, Criteria1:=Sheets("Sheet1").Range("G5").Value

 

[Vexorg]

Like this?

Sheets("3rd Party and Phones").Range("$A$1:$BK$19814").AutoFilter Field:=55, Criteria1:=Sheets("Sheet1").Range("G5").Value

Thanks guys. Thank you thats exactly what i needed. I tried that before but i forgot to add .Value !