Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
I have a line of code that is failing due to a Run Time Error 13 Type
Mismatch. The code is as following: If Application.HLookup(sh.Name, WorkSheetSelectForm.SheetExcludeArray, 2, False) = 0 Then Now I know why its failing. The term sh.Name does not exisit in the Array that I am performing the Hlookup on. However, I need to warp error handling around this so that the code will progress. I have tried wrapping a ISERROR stmt around it to generate a boolean as a start. But I cannot get this to work. When I do the following below in the Immediate Window I get a "Run Time Error 1001Unable to get the Hlookup Property of the Worksheet Function class" ?ISERROR(Application.worksheetfunction.HLookup(sh. Name, WorkSheetSelectForm.SheetExcludeArray, 2, False) = 0) What can I do in order to error handle this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"ByRef argument type mismatch" Error | Excel Programming | |||
Run-time Error "13" - File Type Mismatch | Excel Programming | |||
Help with Run-time error: "Type Mismatch" | Excel Programming | |||
"FIND" generates "Type mismatch" error | Excel Programming | |||
Copying data to another worksheet gives "Type Mismatch" error | Excel Programming |