Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet Another VLOOKUP issue in VBA
Anyone know what I am doing wrong?
Here is a snip of my code: ' Calculate Yardage Set CapRange = Worksheets("TruckInfo").Range("TruckData") Set truck = Me.cboTruckID Set PerFull = Me.txtPerCap TruckCap = Application.VLookup(truck, CapRange, 8, False) vTruckYard = TruckCap * PerFull The "truck" variable is getting set correctly (long type) The "PerFull" variable is getting set correctly (long type) The code hangs-up with the Vlookup segment ("Type mismatch") Is there a special way to pass parameters to VLOOKUP inside of VBA? Help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Worksheet Functions | |||
vlookup issue | Excel Discussion (Misc queries) | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions |