Home > Forum Home > Analyzing Corporate Financial Data > Based on the shape text copy the shapes from 1 sheet to another > Loop through all shapes Share

Loop through all shapes

Excel Help for Loop Through All Shapes in Analyzing Corporate Financial Data


Forum TopicLogin

Loop Through All Shapes

Rate this:
(2.2/5 from 15 votes)
OopsVBA Code:
Dim sh As Variant
For Each sh In ActiveSheet.Shapes
  If sh.Text = "The Sought Text" Then
    sh.Copy
    'do pasting into in new sheet etc.
  End If
Next sh

 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Loop through all shapes in the