Thread: Removing artifacts from a spreadsheet with VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
  
Posts: 1
Default Removing artifacts from a spreadsheet with VBA

Brian, try this code:



Code:
--------------------


Sub removeShapes()
Dim sh As Shape
For Each sh In ActiveSheet.Shapes
sh.Delete
Next sh
End Sub
--------------------


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=192733

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote