Copy Word Art in macro
 

I have a word art that I want to copy to several places in a worksheet. I
tried recording a macro but the copy just picks up cell location - not word
art object. Any idea how to do this? Thanks for any help on this.

Copy Word Art in macro
 

This is what I get when I copy Wordart using recorder.

ActiveSheet.Shapes("WordArt 128").Select
Selection.Copy
Sheets("Sheet3").Select
Range("Q7").Select
ActiveSheet.Paste

Perhaps you are not properly selecting the object?

Right-click on the edge of the object to select and copy.


Gord Dibben MS Excel MVP


On Sat, 17 Oct 2009 06:20:01 -0700, dhstein
wrote:

I have a word art that I want to copy to several places in a worksheet. I
tried recording a macro but the copy just picks up cell location - not word
art object. Any idea how to do this? Thanks for any help on this.