Hello

I have an excel spreadsheet with VB code in it and it works great and all the time on Excel 2000 and 2003.

I am running it on Excel 97 and it seems to work the first time only.

The following line gives me an error 1004, Failed to get the Find property of the Range class

Set c = Worksheets("ListSTB").Range("A1:A100").Find(Riferimento, LookIn:=xlValues)

The logic is this, by clicking on a push button, Worksheet ListSTB is searched for the value stored in thevariable Riferimento.
It goesthrough this in a loop the first time successfully.

If the user decides to redo it, it then fails.

Can anyone help?