Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2006

Tip: Looking for answers? Try searching our database.

Macro for Table Formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Suz H - 13 Oct 2006 20:01 GMT
Please help.  I am working on a table.  Beginning on the 22nd row of the
table, there are 7 rows of 16 cells with a formula sum(left) in the 17th
cell.  and at the end of the 29th row, there is the formula for sum(above).  
I am trying to write a macro that will update these cells automatically.  If
I do it with the update button or the "File, Formulas, OK", it works fine.  I
just can't make it happen automatically.  I have created a button that the
user should be able to use to update all the cells but no matter what I
write, it won't update the cells.  Is there a way to update without clicking
anything.  It is probably something simple but I just can't get it.

I hope some one can help.  I would really appreciate it.
Doug Robbins - Word MVP - 14 Oct 2006 07:46 GMT
The command

ActiveDocument.Range.Fields.Update

will update all of the fields in the body of the document.

If you just wanted to update those in the table itself, use:

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Please help.  I am working on a table.  Beginning on the 22nd row of the
> table, there are 7 rows of 16 cells with a formula sum(left) in the 17th
[quoted text clipped - 11 lines]
>
> I hope some one can help.  I would really appreciate it.
Suz H - 14 Oct 2006 16:04 GMT
Thank you so so much for your quick reply.  I am on my way out the door with
my computer so I will try this soon.  I don't have a lot of experience with
numbers in word (except to sum left, right and above) and I knew it was going
to be a simple one line thing but couldn't get it.  Thanks again.

> Please help.  I am working on a table.  Beginning on the 22nd row of the
> table, there are 7 rows of 16 cells with a formula sum(left) in the 17th
[quoted text clipped - 7 lines]
>
> I hope some one can help.  I would really appreciate it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.