| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax Error in VLOOKUP Code
I have the following code as part of a larger macro.
For ILoop = NumRowsIFCAP To 1 Step -1 IF(ISERROR(VLOOKUP(Cells(Iloop,1),FileOpenNameF850 !$A$1:$C$NumRowsF850,2,FALSE))) then (More code...) End If Next Iloop "FileOpenNameF850" is a string variable that holds a workbook name that contains one worksheet. I can't get the syntax correct in the VLOOKUP line of code. What is the correct syntax? TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax problem with code | Excel Discussion (Misc queries) | |||
| VBA code to sum a row: syntax needed | Excel Discussion (Misc queries) | |||
| Vlookup Syntax Error | New Users to Excel | |||
| help with code/syntax | Excel Programming | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Threaded Mode
