+ Reply to Thread
Results 1 to 6 of 6

[SOLVED] code exceeds max. # of characters per line

  1. #1
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    [SOLVED] code exceeds max. # of characters per line

    How do i start a new line of code if i exceed the max. # of characters?

    here is my code: i did to continue the Range to a new line.

    Please Login or Register  to view this content.
    Last edited by adamheon; 02-19-2014 at 11:36 AM.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: code exceeds max. # of characters per line

    If this range is static you could create a named range and use that....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: code exceeds max. # of characters per line

    Another solution something like

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Note that you don't have to select the range
    If you are pleased with a member's answer then use the Star icon to rate it.

  4. #4
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    Re: code exceeds max. # of characters per line

    I'm sorry I added the wrong code....could you show how it should look with this code?

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: code exceeds max. # of characters per line

    Something like this

    Please Login or Register  to view this content.

    However my personal preference would be to declare a variable of type range that will hold reference to the range in question

  6. #6
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    Re: code exceeds max. # of characters per line

    Thank you!

+ 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. Replies: 1
    Last Post: 08-30-2013, 04:56 PM
  2. importing data that exceeds 255 characters
    By dmac_59 in forum Excel General
    Replies: 0
    Last Post: 10-31-2007, 06:22 PM
  3. [SOLVED] Calculating a formula that exceeds 1,000 characters
    By w1nter11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 09:25 AM
  4. Delete A Word That Exceeds X Number Of Characters
    By brazen234 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2005, 12:40 PM
  5. [SOLVED] Footers in which number of characters exceeds 255
    By DRK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-09-2005, 01:05 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