Just needed to delete a lot of charts. I'm generating some as well and all the practice charts are building up.
********************************
For i = 1 To ActiveSheet.ChartObjects.Count 'Cycle through the Charts
ActiveSheet.ChartObjects(i).Delete ' Delete each Chart
Next i 'NEXT CHART
**********************************
The bulk of the code is in this loop. Surrounding code is pretty easy
Showing posts with label vba. Show all posts
Showing posts with label vba. Show all posts
Tuesday, May 26, 2009
Tuesday, May 19, 2009
Escape Hard Return in VBA
It's always a pain to remember a hard return in VBA. So I thought I'd get it documented. There is actually more than one. I may post the differences in a future post.
---- CODE ------
vbCrLf
vbNewLine
---- END CODE ------
---- CODE ------
vbCrLf
vbNewLine
---- END CODE ------
Subscribe to:
Posts (Atom)