Results 1 to 4 of 4

Print cell with a ton of text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-09-2006
    Posts
    109

    Question Print cell with a ton of text

    I'm building a form and there's one section where the user will likely copy and paste a huge block of text from word or similar into excel. My eventual goal is getting this to print, but at the moment I can't even get all the text to show in a single cell (Excel won't allow me to expand the cell by width or height enough to show all the text). I've also tried text boxes, but those cut off very early compared to just a cell. To give you an idea, I did a len() on the cell and it's about 6000 characters.

    Any idea how I could get this to show up and print on a page? I have several macros in this file already so I've got no problem adding another. I was thinking I could parse through the text looking for carriage returns then separate the paragraphs into different cells. I thought someone else might have a better idea than parsing through it.

    Thanks in advance for the assistance!

    Chris
    Last edited by cbh35711; 01-28-2016 at 01:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Try to print text from userform in cell but VBA returns a 0
    By jeroenv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2015, 10:54 AM
  2. Text in cell that has "wrap text" getting cut off on print/print preview.
    By Phillips Contracting in forum Excel General
    Replies: 3
    Last Post: 05-01-2014, 01:44 AM
  3. Block any print out when a certain cell is empty (=no text)
    By Postlki1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 08:25 AM
  4. If cell is active (text in cell) print area (A1:?52) Please see code I think I am Close
    By Jeff up North in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2013, 06:27 PM
  5. All Text in Cell not visible and does not all print
    By excelclutz in forum Excel General
    Replies: 0
    Last Post: 09-14-2010, 03:17 PM
  6. Replies: 1
    Last Post: 05-25-2005, 01:06 PM
  7. [SOLVED] How do I print all the text in a cell
    By Dorna Tucker in forum Excel General
    Replies: 4
    Last Post: 02-03-2005, 01:06 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