Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I'm having a problem at the last line of this code: For Each ws In Workbooks(sFile).Sheets If ... Then cboSheet.AddItem ws.Name End If Next The problem occurs when I step into a chart sheet, which results in a type mismatch error. Why does that happen how do you handle that? Gustaf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copied sheet causing duplicate range name error (Excel 2010) | Excel Discussion (Misc queries) | |||
What's causing error message? | Excel Worksheet Functions | |||
What's causing error message? | Excel Programming | |||
Query causing #ref error in spreadsheet | Excel Discussion (Misc queries) | |||
INSERT INTO sql statement causing error | Excel Programming |