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

Based on the shape text copy the shapes from 1 sheet to another

Excel Help for Based On The Shape Text Copy The Shapes From 1 Sheet To Another in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Based On The Shape Text Copy The Shapes From 1 Sheet To Another

Rate this:
(2.7/5 from 6 votes)
ConfusedBased on the shape text select the shape & copy the shape from one sheet to another
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
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 on
 Displaying page 1 of 1 

Excel templates and solutions matched for Based on the shape text copy the shapes from 1 sheet to another:

Solutions: Bar Code Generator

© Business Spreadsheets   Legal   Follow us: