| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mismatch Error
I'm getting a type mismatch error on the following section of code - any ideas?
======== Set wsDest = Workbooks("NI Insurer Market Share as at " & Format(Date, "yyyy-mmmm") & ".xls").Worksheets(Array("PC (Chart)-NI-MONTH", _ "PC (Chart)-NI-YTD", "PC (Chart)-NI-R12", "HH (Chart)-NI-MONTH", _ "HH (Chart)-NI-YTD", "HH (Chart)-NI-R12", "CV (Chart)-NI-MONTH", _ "CV (Chart)-NI-YTD", "CV (Chart)-NI-R12")) ======== Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
| xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
| Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Threaded Mode
