Find generates error message
Can anyone tell me why the following code
With xlSHT.Range("c1")
Set c = .Find(sName, "c1", xlValues, , xlByColumns, xlNext)
End With
Generates the error message: "unable to get the find property of the Range
class"
xlSHT is a worksheet object that has been set to a worksheet in an open
workbook. "c" is a range object. Any help would be greatly appriciated.
Jim
|