Copy Word Art in macro

D

dhstein

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Art in Excel 4
don't print word art 6
Word Art 4
Overrighting ( bring to front) 1
Animated Clip Art 1
vba code for inserting word art using in excel 2007 1
Help! Draft Watermark Won't Go Away 6
Text boxes and word art NOT printing 1

Top