[Fev]

On Mar 12, 2:55*pm, Fev wrote:
On Mar 12, 1:09*pm, "macropod" wrote:





Hi Fev,

Your problem description suggests the cell containing the bookmark is included in one or more of the bookmarked ranges. Since you
evidently know which cells to add the bookmarks to, why not simply use the cell addresses in your formula?

--
Cheers
macropod
[MVP - Microsoft Word]

"Fev" wrote in ...
Hi
I have a table in Word 2003 or Word 2007 (I am testing this document
in both versions) that adds a number of bookmarks in the same row {=sum
(Balcon1,OPS1,Park1,Rental1,Str1)} that works well, until I choose to
recalc the cell, table or the document. *Each time a recalc happens
the formula coumpounds itself - the intitial answer is 1,602.00. *The
next recalc provides the result *8,609.62, then 15,617.24 etc. *Is
there a way to prevent this?
Thanks
Heather- Hide quoted text -

- Show quoted text -

Hi
Thanks for your quick response, I was using bookmarks as the values in
the table are the result of a mailmerge from a large csv file and we
then bookmarked all merge fields to be used in various calculations.
I have tested it using the table cell references and it doesn't
compound. *I know I had a similar problem a while ago and after
redoing the bookmarks and the formula the problem appeared to be
resolved. *I was just wondering where I was going wrong with the
bookmark story.

Is there a way to view the names and locations of all bookmarks in the
document? *I am viewing bookmarks so I can see the [ * *] but would
like to see their names as well. *I know I can use Goto bookmark, but
that would be rather tedious as there are over 100 bookmarks in the
document.
Thanks
Fev- Hide quoted text -

- Show quoted text -

I have just run some code that shows a message box for the bookmark
that I have selected and discovered that 2 cells were being referenced
by the same bookmark. I gather this created a circular reference.
Thanks once again.