Loop through all shapes

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

Loop Through All Shapes

Rate this: (2.2/5 from 15 votes)

	VBA 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 Excel Helper on 21 Oct 2011

View Full Post