I am trying to find the content of range("countryname") within the whole
sheet to scroll to it. I am using the following code, but it does not work
because the cells I am trying to find contain the country name as formulae.
it works only when the country name is written not as formulae. Any idea?

Dim wks As Worksheet
Set wks = ActiveSheet

wks.Cells.Find(wks.Range("countryname").Value,
wks.Range("countryname")).Select

ActiveWindow.ScrollRow = Selection.Row



--
caroline