| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Issue
I have a variable assigned to Variant type and I have this statement before
The variable is assigned: On Error Goto XXXX THe variable gets its value as follows: Res = Application.VLookup(Cells(X, 1) & Cells(X, 41), LookupRng, 3, False) The result is error 42, but the application does not goto XXXX but instead I get an error 42, runtime error 13, type mismatch. I am not sure what to do I can't seem to get the program to just skip over the assignment. Suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple variable issue | Excel Discussion (Misc queries) | |||
| subroutine variable decleration issue | Excel Programming | |||
| Object variable issue | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| OutlineLevel and Integer Variable issue | Excel Programming | |||
Threaded Mode
