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.
|