[SOLVED]Reference cells and pivots in other tabs

[4am]

I know this is easy stuff but I am rusty on my VBA and just need some help with this code:

 ActiveSheet.PivotTables("PivotTable3").PivotFields("IP1").CurrentPage = _
        ActiveSheet.Range("V6").Value

I want to modify this code to change the pivot field "IP1" in PivotTable3 in a sheet called "ARAP" to match the value of cell B8 in a sheet called "REF"
I am no longer using the active sheet. Both the pviot table that needs to change and the value I need to change it to are in different sheets from the button that executes the macro.

Thank you so much for all your help around here!

[watersev]

hi 4am,

Sheets("ARAP").PivotTables("PivotTable3").PivotFields("IP1").CurrentPage = Sheets("REF").Range("B8").Value

[4am]

Thank you so much!! I know this is simple stuff, I just haven't done programming in a while!