+ Reply to Thread
Results 1 to 2 of 2

A Macro to set the table cells formatting

Hybrid View

  1. #1
    Registered User
    Join Date
    02-12-2015
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010
    Posts
    1

    A Macro to set the table cells formatting

    Hi,

    I am using requirements management tool to export a document in Ms word. Whenever I export the doc, table cells format gets disturbed. BA will be using this tool to export this document and manually setting this stuff is quite frustrating. Could we have a macro that will run to fix the formatting issue.

    Using VBA Macros, how can I access each tables row and the number of cells it have? Furthermore, based on the number of cells in a particular row of a table I want to set its width in percentage.

    For example, one row has two cells in it and I want to assign 30% width to the first cell and 70% to the second. Second row has four cells in it and i want to assign 25% of width to each one of the cells.

    I hope I am able to explain what I want. Please let me know if I have to give you more details. Looking for your help.

    Regards,
    Usman

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: A Macro to set the table cells formatting

    x = range("table1").rows.count
    i = range("table1").columns.count


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Formatting table with dynamic merged cells
    By mani_bbc05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2013, 12:15 PM
  2. Formatting Word table cells
    By tania19b in forum Word Formatting & General
    Replies: 1
    Last Post: 01-13-2013, 07:16 PM
  3. Pivot Table graph looses formatting after running formatting macro
    By arthurbr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2011, 04:16 AM
  4. Replies: 3
    Last Post: 04-15-2009, 11:50 PM
  5. Conditional formatting Macro whole table at once
    By p3te2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2007, 12:50 PM

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