+ Reply to Thread
Results 1 to 6 of 6

Large Mysterious Text

Hybrid View

dougman824 Large Mysterious Text 07-28-2017, 10:07 AM
Glenn Kennedy Re: Large Mysterious Text 07-28-2017, 10:19 AM
dougman824 Re: Large Mysterious Text 07-28-2017, 10:21 AM
Glenn Kennedy Re: Large Mysterious Text 07-28-2017, 10:22 AM
Keebellah Re: Large Mysterious Text 07-28-2017, 10:23 AM
AliGW Re: Large Mysterious Text 07-28-2017, 10:26 AM
  1. #1
    Forum Contributor
    Join Date
    06-12-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    167

    Large Mysterious Text

    Hello,

    I never noticed this crazy happening until I was training people and it was pointed out to me but I have these massive words being printed that shouldn't be there. I have tried a few ways to get rid of them since they are messing up my print area big time. Here is what I have tried:

    1. If I clear the entire sheet they do not disappear.

    2. I have entered developer mode and was unable to select them

    3. I checked the headers and footers and they weren't there

    4. I went to page break view and it shows the sheets as grey which I believe means they shouldn't print but when I go to print it still wants to print 252 pages.

    It really doesn't make sense.

    Here is a picture and a copy of the sheet

    Big Font Bust.JPG
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Large Mysterious Text

    Delete the two named ranges stage and stage1 and probably Blah (!!) as well. Indeed your named ranges look a bit of a mess. go through them carefully and weed out the dross.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Contributor
    Join Date
    06-12-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    167

    Re: Large Mysterious Text

    THANK YOU THANK YOU THANK YOU!!! I forgot I set those weeks ago and we could not figure it would at all

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Large Mysterious Text

    and then delete the named range Print area, too.
    Attached Files Attached Files

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Large Mysterious Text

    Nothing busted there, just a external links and a table.
    I suggest you cleanup your work
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,029

    Re: Large Mysterious Text

    It was the final stage named area that was the culprit.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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. adding a large, LARGE amount of text to a spreadsheet
    By Wolfpackfan in forum Excel General
    Replies: 4
    Last Post: 05-30-2016, 01:30 PM
  2. [SOLVED] Mysterious Spacing Turn Number Into Text With Leading Zero
    By jackgan in forum Excel General
    Replies: 5
    Last Post: 07-31-2013, 10:35 AM
  3. Help replacing large amount of text with another large amount of text??
    By floydrob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2012, 05:01 AM
  4. Large Form Help: Handling large number of text boxes and labels
    By laterdaysluke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2010, 03:12 PM
  5. Mysterious Text Boxes Appear in .xls format
    By carlas in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-16-2010, 11:04 AM
  6. [SOLVED] Text not continuing to wrap for large block of text in Excel cell
    By Mandra in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2006, 02:15 PM
  7. [SOLVED] Not all text wraps in a cell containing large amount of text
    By Kris in forum Excel General
    Replies: 3
    Last Post: 12-23-2005, 12:30 PM

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