Results 1 to 6 of 6

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

Threaded View

adamheon [SOLVED] code exceeds max. #... 02-19-2014, 10:34 AM
judgeh59 Re: code exceeds max. # of... 02-19-2014, 10:47 AM
buran Re: code exceeds max. # of... 02-19-2014, 10:50 AM
adamheon Re: code exceeds max. # of... 02-19-2014, 11:05 AM
buran Re: code exceeds max. # of... 02-19-2014, 11:11 AM
adamheon Re: code exceeds max. # of... 02-19-2014, 11:35 AM
  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.

    Sub ClearForm()
        ActiveSheet.Unprotect Password:="pec123"
        Range("D1:G5,C7:AC8,D11:D14,D22:D25,D33:D36,D44:D47,D55:D58,D66:D69,D77:D80,D88:D91,D99:D102,D110:D113,D121:D124,D132:D135,D143:D146,D154:D157,D165:D168,H11:Z171,AB17,AB28,AB39,AB50,AB61,AB72,AB83,AB94,AB105,AB116,AB127,AB138,AB149,AB160,AB171").Select
        Selection.ClearContents
        ActiveSheet.Protect Password:="pec123", DrawingObjects:=True, Contents:=True, Scenarios:=True _
            , AllowFiltering:=True
    End Sub
    Last edited by adamheon; 02-19-2014 at 11:36 AM.

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. 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. 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