Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I've been using the search feature, but haven't crossed over a situation where someone needed to determine if a chart exists. I am giving the user the ability to run a snippet of code over again if they change something. It essentially will regraph everything. I want to first delete the Chart it had previously made if there were one and then recreate it. Here is my code below. I have an error message with the first line. The two arr* terms are arrays that have a defined name. Set shtnme = Worksheets(arrFileList(FileNum) & "_" & arrLayers(LayerNum)) 'Delete graph if already there cause user reran graphing tool If Not shtnme Is Nothing Then Sheets(shtnme).Delete Else: End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determine if Sub Exists | Excel Programming | |||
VBA:: determine if UDF exists? | Excel Discussion (Misc queries) | |||
Determine if a File Exists | Excel Discussion (Misc queries) | |||
Determine if a File Exists | Excel Programming | |||
determine if value exists | Excel Programming |