How about selecting the TOC, copy, right+click a cell, paste (or use a Paste
Special option)?
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 11/9/06 7:03 PM, in article uvzG0uFBHHA.4472@TK2MSFTNGP03.phx.gbl,
> Hi
>
[quoted text clipped - 7 lines]
> Any help would be appreciated.
> Thanks :)
Sydney - 13 Nov 2006 03:36 GMT
Not quite what we are after.
I am trying to automate it so that when the TOC is updated, its
automatically updated in the excel doc too.
Thanks anyway
> How about selecting the TOC, copy, right+click a cell, paste (or use a Paste
> Special option)?
[quoted text clipped - 16 lines]
> > Any help would be appreciated.
> > Thanks :)