Application Defined or object-defined error

[Hacktastic]

Hello, I have this small vba code that takes the value of a named range and tell it to change that field to that given value in a pivot

Sub CarrierControl()

Sheets("pvts").PivotTables("Master").PivotFields("network operator").ClearAllFilters
Sheets("pvts").PivotTables("Master").PivotFields("network operator").CurrentPage = Range("Carriertwo").Text

end sub

carriertwo is the name of the range and passes in values correctly. if I hardcode the value to the pivot, it works. but it wont work with the named range.

any help would be greatly appreciated.

Chris

 

[Hacktastic]

wow....

everyone who ever had this issue, please use

.value

instead of

.text

Thanks