Countrylist is defined as a range object

despite value being the default property try
CurrentPage = CountryList.Value

might work in Xl2003, but not sure whether it'll work in 2007.

You have to make sure the value of Countrylist is actually present in
the pivottable field "Investigator
Country", otherwise this can be another reason for an error.