Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error handling - check chart existance
I've a chart sheet namely "chart1" and I want to check if this char
exists in the file before calling other functions. without checkin this in the working file and that the chart does not exist. is there a question to catch this?:rolleyes -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error handling - check chart existance
Hi annette
Sub test() Dim ch As Chart For Each ch In ThisWorkbook.Charts If ch.Name = "Chart1" Then MsgBox "Chart exists" Exit For End If Next ch End Sub -- XL2002 Regards William "annette2002 " wrote in message ... | I've a chart sheet namely "chart1" and I want to check if this chart | exists in the file before calling other functions. without checking | this in the working file and that the chart does not exist. | is there a question to catch this? | | | --- | Message posted from http://www.ExcelForum.com/ | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handling - Check a file isn't already open before overwritin | Excel Discussion (Misc queries) | |||
Error Handling | Excel Discussion (Misc queries) | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Error Handling | Excel Programming | |||
Existance Check Fails | Excel Programming |