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.3/5 from 3 votes)
OopsVBA Code:
Dim sh As Variant
For Each sh In ActiveSheet.Shapes
  If sh.Text = "The Sought Text" Then
    '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