Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart sheet causing error
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart sheet causing error
You probably have ws defined as a variable of type worksheet. Either change
it to Object, or outsort the charts n the code. HTH Bob "Gustaf" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart sheet causing error
You're right. The ws variable is indeed defined as Worksheet. It's preferred, because that's how it's done in the rest of the project. However, I don't think outsorting the charts would work, because the error occurs already on the "Next" line, before returning to the top of the loop.
Gustaf Bob Phillips wrote: You probably have ws defined as a variable of type worksheet. Either change it to Object, or outsort the charts n the code. HTH Bob "Gustaf" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart sheet causing error
If you keep it as type worksheet, you HAVE to outsort the charts, otherwise
it will just fail as you have found. HTH Bob "Gustaf" wrote in message ... You're right. The ws variable is indeed defined as Worksheet. It's preferred, because that's how it's done in the rest of the project. However, I don't think outsorting the charts would work, because the error occurs already on the "Next" line, before returning to the top of the loop. Gustaf Bob Phillips wrote: You probably have ws defined as a variable of type worksheet. Either change it to Object, or outsort the charts n the code. HTH Bob "Gustaf" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart sheet causing error
It is easily outsorted like so
Dim ws As Worksheet For Each ws In Workbooks(sFile).Worksheets If ... Then cboSheet.AddItem ws.Name End If Next HTH Bob "Gustaf" wrote in message ... You're right. The ws variable is indeed defined as Worksheet. It's preferred, because that's how it's done in the rest of the project. However, I don't think outsorting the charts would work, because the error occurs already on the "Next" line, before returning to the top of the loop. Gustaf Bob Phillips wrote: You probably have ws defined as a variable of type worksheet. Either change it to Object, or outsort the charts n the code. HTH Bob "Gustaf" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart sheet causing error
Thank you very much! :-)
Gustaf -- Bob Phillips wrote: It is easily outsorted like so Dim ws As Worksheet For Each ws In Workbooks(sFile).Worksheets If ... Then cboSheet.AddItem ws.Name End If Next HTH Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |