Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time error 13 type mismatch
Dim days As Variant Dim hours As Variant Dim holOptElig As Variant Dim wb As Workbook Set wb = Workbooks("Salary and Hourly Summary 2009.xls") days = wb.Names("MikeNbrHolidays").Value hours = wb.Names("MikeTotalHolHours").Value If days 0 Then holOptElig = hours / days <== error on this statement End If In "Salary and Hourly Summary 2009.xls", MikeNbrHolidays and MikeTotalHolHours are formatted as number/0 decimal places and number/1 decimal places respectively, and their values are 8 and 43.2. When I run this code I get run time error 13, type mismatch. I tried a couple different type for these variables and nothing seems to help. TIA, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run-time error 13: Type mismatch? | Excel Discussion (Misc queries) | |||
run time error 13 type mismatch | Excel Programming | |||
Run Time Error 13 Type Mismatch | Excel Programming | |||
Run-time error '13':Type mismatch | Excel Programming | |||
run time error 13 type mismatch | Excel Programming |