+ Reply to Thread
Results 1 to 1 of 1

Alignment of multiple rows

  1. #1
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    174

    Alignment of multiple rows

    I'm inserting a field that has multiple rows in it.

    i.e.:
    Line1
    Line 2 has more stuff
    Line 3 has even more stuff
    etc...

    depending on the data source there could be 1 row, or 10 + rows.

    I'm grabbing the data from an access table and inserting it into the word document... it all works, but the last insert doesn't vbTab over to the correct spot because "Details" is multiple rows of text.
    The red text is the line I'm not sure why it's not working. I'm splitting the "Details" up by vbCr and putting it into an array (myArray), then looping through the array and putting the data in word.. it only works for the first array value.


    Please Login or Register  to view this content.
    Last edited by Cobra17; 09-27-2021 at 05:37 PM.

+ 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. Middle Alignment Spacing between rows
    By sunriver61 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2020, 03:21 PM
  2. Excel VBA : Mix rows without breaking the alignment of the columns
    By Berktan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2017, 07:22 AM
  3. Horizontal bar chart alignment with rows
    By xs2deepak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-26-2015, 05:04 AM
  4. Help with moving multiple columns and checking alignment
    By TheMegs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2012, 05:54 PM
  5. Concatenate with multiple alignment
    By tigabalm in forum Excel General
    Replies: 2
    Last Post: 04-04-2011, 09:53 PM
  6. How to change the alignment of multiple cells
    By Raptors in forum Excel General
    Replies: 2
    Last Post: 09-01-2010, 06:29 PM
  7. [SOLVED] Alignment of Multiple-Level Category Labels Not Possible?
    By MCP in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2005, 03:06 AM

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