PDA

View Full Version : Size chart to Word cell



michelle.lee
08-11-2008, 09:48 AM
Hi,

I've seen this macro used before but have no idea how to go about re-creating, hopefully someone can help me?

I want to size a chart in excel to fit a word cell exactly. I know:
- the word cell needs to have an exact row height
- the curser needs to be in the word cell you want to size the chart too when you use the tool
- you can only have one word document open so the tool doesn't get confused what it is supposed to be sizing too

Any ideas?


Thanks,
Michelle

marshybid
08-12-2008, 08:11 AM
Hi Michelle,

This thread might shed some light for you

http://www.vbaexpress.com/forum/showthread.php?t=17142

Marshybid