+ Reply to Thread
Results 1 to 2 of 2

VBA to insert and merge cells until all text in column is visible

  1. #1
    Registered User
    Join Date
    05-21-2009
    Location
    Ok, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    VBA to insert and merge cells until all text in column is visible

    I have countless spreadsheet reports that I need to convert to printable format. The issue is that one of the columns in each spreadsheet contains a large amount of text, which requires me to insert a row(s) below the cell and then merge the cells in order to make the text visible/printable. I have attached a sample report/spreadsheet for reference. Column "D" is the column at issue.

    Is there a way to print all of the text in Column D without going through this process? If not, would it be possible to make a macro that would detect whether the text in Column D exceeds the maximum cell height and, if so, add and merge rows below it until all of the text is visible?

    I greatly appreciate any help!

    https://drive.google.com/file/d/0B5V...ew?usp=sharing

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA to insert and merge cells until all text in column is visible

    You can use VBA to automatically adjust the column width to the size of the text in the column. Below is the code..
    Please Login or Register  to view this content.
    Place it in ThisWorkbook module

    PS - There was nothing on the link you provided.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

+ 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. Find given text in column A and Merge all Cells data in that row in
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2015, 03:27 PM
  2. Insert Rows in between cells of text in different column
    By king10001 in forum Excel General
    Replies: 2
    Last Post: 05-26-2015, 11:46 AM
  3. [SOLVED] Insert New row to add more rows to merge range with wrap text
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2014, 01:27 PM
  4. [SOLVED] Count only visible cells containing text
    By shameus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2014, 05:56 PM
  5. copy visible cells and insert into report
    By alexcrofut in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2014, 12:05 PM
  6. VBA for filtering a column then filling down a text for visible cells in another column
    By rajkumarmp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2013, 04:00 PM
  7. how insert same text in empty cells in column (10000 rows)
    By bromptongadgets in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2005, 11:15 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