clearing tables before updating with macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that updates a summary table with user entered information in a detail table
This macro can be run a number of times
How do i clear the summary table before updating it via the macro

Many thanks
 
Here's one way:

Dim pCell as Word.Cell

Set pCell = Selection.Tables(1).Cell(1,1)
Do
pCell.range.text = ""
set pCell = pCell.Next
Loop until pCell is nothing
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary table for track changes 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Populate word footnotes from table 0
Macro for Revision Summary (Tracked changes) 0
Update Fields Problem 2
Access Macro Repeat Expression using value of a field in table 0
How can I create a table of contents in in a table format? 3
Help to create a macro 2

Back
Top