Macro to recalculate fomulas in a table

[Guest]

Thanks for reading this post.

I have a tables whcih containes data in columns "B" and "C". In column "D",
I have used formulas to calculate the difference between columns "B" and "C"
in the same row. Similarly, in column "E", I have formulas to caculate the %
of column "D" against "C" in the same row.

When the data in columns "B" and "C" are updated (manually) I wish to
recalculate columns "D" and "E" using a Macro (instead of selecting each cell
containing a formula individually and pressing function key - F9).

Can any one give me a solution?

Thanks

 

[Beth Melton]

You can record a macro for this ( Tools/Macro/Record new macro) when
you are recording, press Ctrl + A to select your document then F9 to
update your fields.

Once you have your macro you can assign it to a button on your toolbar
(or do this before you start recording). For more information take a
look at:
http://word.mvps.org/FAQS/Customization/AsgnCmdOrMacroToToolbar.htm

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Guest]

Thanks a lot Beth.

It works fine.

Well "Ctrl + A" Selects the entire document. Is there any way I could select
only a particular table in the document?

Thanks

 

[Jezebel]

selection.Tables(1).Range.Fields.Update

Thanks a lot Beth.

It works fine.

Well "Ctrl + A" Selects the entire document. Is there any way I could
select
only a particular table in the document?

Thanks

 

[Guest]

Thanks Jezebel for your response.

I would be much obliged if you could kindly elaborate a little your answer.