Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two workbooks that have been set up with the same layout and formating
etc. When I run a macro that contains the following code (see below), pointed to one workbook, everything runs fine. But when I point to the other workbook, I get a Run-time error '13': Type mismatch. Code from macro: For Each cell In TimeSrcRng If cell.Value < "" Then If cell.Value = dtStart And cell.Offset(0, 1).Value <= dtEnd Then cell1 = cell.Offset(0, -2).Value Set cell1 = cell1.Offset(1, 0) End If End If Next The error occures on line: If cell.Value = dtStart And cell.Offset(0, 1).Value <= dtEnd Then How can I figure out what's wrong with the second workbook? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |