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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time error 13 type mismatch
Phil, is the workbook wb already open? cellist;218861 Wrote: Code: -------------------- 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 -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60147 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time error 13 type mismatch
Simon, thanks for your reply.
Yes, the workbook is open and it turns out to be a different problem. Take a look at my identical posting of a few moments earlier. When I first posted, I got an error saying the my post had failed due to a system problem, so I re-posted. Got the error again!! I gave up and when I checked back BOTH messages had actually posted. "Simon Lloyd" wrote: Phil, is the workbook wb already open? cellist;218861 Wrote: Code: -------------------- 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 -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60147 |
Reply |
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 |