+ Reply to Thread
Results 1 to 5 of 5

clearing cell content of certain cells in multiple mixed column width tables MS WORD

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Smile clearing cell content of certain cells in multiple mixed column width tables MS WORD

    I have the following tables in a WORD document:

    Screenshot 2015-07-16 18.21.50.png
    This image shows two of the tables.
    Each Table's first row only has one column (one cell)
    The rest of the rows consist of 5 columns.

    I need to EITHER:
    - clear the content of the last 3 columns (they contain prices)
    or
    - delete columns 3,4 and 5. (they contain prices)

    I am not too concerned what happens with the table as a whole in terms of formatting, but my biggest challenge is this first row which must stay intact.

    I found this code, but it does not work due to my first row. Also, this only does one column, but I do not mind that too much. Any assistance will be greatly appreciated.
    Please Login or Register  to view this content.
    Thanking you in advance, with love from South Africa.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: clearing cell content of certain cells in multiple mixed column width tables MS WORD

    You can clear the cells with:

    Please Login or Register  to view this content.
    This will run for all rows per table, excluding the first.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: clearing cell content of certain cells in multiple mixed column width tables MS WORD

    Two approaches:
    1. clear the cells; or
    2. delete the cells
    Please Login or Register  to view this content.
    In neither case do you need to select anything.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Registered User
    Join Date
    06-25-2015
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: clearing cell content of certain cells in multiple mixed column width tables MS WORD

    Quote Originally Posted by daffodil11 View Post
    You can clear the cells with:

    Please Login or Register  to view this content.
    This will run for all rows per table, excluding the first.
    @ daffodil11
    Thank you so much, this worked flawlessly the first time!! I'm so happy, you made my day.

  5. #5
    Registered User
    Join Date
    06-25-2015
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: clearing cell content of certain cells in multiple mixed column width tables MS WORD

    Thank you Mr Edstein, much appreciated! I am learning so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cells & tables formats depending on another cell content
    By ThomassoCZ in forum Excel General
    Replies: 1
    Last Post: 12-17-2014, 10:56 AM
  2. clearing content from blank cells
    By cotw in forum Excel General
    Replies: 6
    Last Post: 08-11-2012, 01:44 PM
  3. Replies: 2
    Last Post: 07-14-2012, 02:08 AM
  4. [SOLVED] Exclude column when clearing content with VBA
    By newrui in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2012, 11:37 AM
  5. Replies: 1
    Last Post: 05-02-2007, 10:36 PM
  6. Replies: 4
    Last Post: 06-01-2006, 05:00 AM
  7. [SOLVED] Change column width according to specific cell content
    By RosH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2005, 11:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1