View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Houston James Houston is offline
external usenet poster
 
Posts: 1
Default 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