| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink selection generates error message | Links and Linking in Excel | |||
| Disable find files error message for missing links on opening WB | Excel Discussion (Misc queries) | |||
| cutting and pasting rows from one sheet to another generates error | Excel Discussion (Misc queries) | |||
| Excel Analysis Add-in EOMONTH generates #NAME? error | Excel Worksheet Functions | |||
| Copy generates an automation error. | Excel Programming | |||
Threaded Mode
