Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm having an issues with this simple code and can't figure it out. I
always get the type mismatch error. I do have a range named StatusTable, so that's not the problem. Please help. Sub msg() Dim i, j, k As Integer i = 1 j = 3 If Application.VLookup(Worksheets(i).Range("A" & j) & Worksheets(i).Range("D" & j), Range("StatusTable"), 2, False) = "Paid" Then MsgBox ("Correct") Else: MsgBox ("Error") End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Type Mismatch | Excel Programming | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Type Mismatch now, not before | Excel Programming |