| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy information from Excel to Word using 1 macro | Excel Discussion (Misc queries) | |||
| Copy from WORD to EXCEL using a macro..... | Excel Discussion (Misc queries) | |||
| Macro to copy a word doc into an excel doc | Excel Discussion (Misc queries) | |||
| copy from Excel to Word by macro with certain for | Excel Discussion (Misc queries) | |||
| copy from Excel to word by macro with certain format | Excel Discussion (Misc queries) | |||
Linear Mode
