| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function match - run time error
Why does the statement give a run time error
If IsError(Application.WorksheetFunction.Match(chk_hd r1, hdr_rng2, 0)) Then where chk_hdr1 is a variable and hdr_rng2 is a column range name. It gives the run time error 1004, Unable to get the match property of the worksheetfunction class. This happens only when the value of chk_hdr1 is not found in hdr_rng2 -- Sajit Abu Dhabi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time interval worksheet function | Excel Worksheet Functions | |||
| Run-time error 1004: Cannot shift nonblank cells off the worksheet | Excel Discussion (Misc queries) | |||
| Match Function - no room for error | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
| The Help on the Excel Edate worksheet function contains an error:. | Excel Worksheet Functions | |||
Threaded Mode
