Look up the responses to your post from yesterday.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Richard John" wrote in message
...
I'm building an Office Application including Excel using Office 2000
Professional running under XP Pro (SP2)

I have embedded several Excel tables and associated graphs in a Word
document using VBA. The problem is that a number of surplus table rows are
appended after each graph in Word, causing unnecessary page breaks in
Word, which then have 2B manually deleted.

Each table and graph is assigned a range name in Excel. The range
definition covers the table and the graph completely which I think is
causing the problem. Does anyone know of a "clean" way to pluck out Excel
tables and graphs for embedding into Word without all those surplus table
rows? eg. Is it possible to just plug the graph into Word from Excel using
VBA?


--

Richard John