Thanks, but an enhanced metafile isn't the same as an MS Office Drawing
Object - rotating the picture isn't the issue, matching the exact format is.

Thanks, but still looking...

"Gord Dibben" wrote:

Select the range.

SHIFT + Edit.

Select Copy Picture.........as shown on screen.

Open Word and Paste SpecialPicture(Enhanced Metafile)

This you can rotate.

If you want the data picture to be dynamic in Word, use the Camera Tool to take
the picture and paste special etc.

Camera Tool is found under ToolsCustomizeCommandsTools


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 09:25:01 -0800, sir23
wrote:

How would I save a selected range from an MS Excel worksheet into a MS Office
Drawing Object - the picture format that can be easily rotated in MS Word.
Unfortunately no other picture formats will substitute... Thanks!