I am trying to use a loop to delete any worksheet that ends in 'Chart
using the following code:
Dim ws As Worksheet
For Each ws In Worksheets
If Right(ws.Name, 5) = "Chart" Then ws.Delete
Next
However, this code does not appear to pick up worksheets created wit
through the chart wizard.
I have stepped through the code and can see that it skips the workshee
with a chart.
Are chart worksheets different in some way to normal worksheets?
Please help
--
stuartmars
-----------------------------------------------------------------------
stuartmarsh's Profile:
http://www.excelforum.com/member.php...fo&userid=2214
View this thread:
http://www.excelforum.com/showthread.php?threadid=57134