Results 1 to 10 of 11

Thread: Handling string in an array of length greater then 255 in excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Thanks for the feedback
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    15
    Also be aware that a Range cannot exceed 255 characters - or maybe it is 256 - so if you are getting data from all over the sheet be careful - this has caused me many headaches. Since we are on the topic of 255(256) - be aware that you can only have 255 seriescollections in a chart. This must be a left over from the days of 8 bit computers.
    xl2007 - Windows 7
    xl hates the 255 number

Similar Threads

  1. Replies: 2
    Last Post: 05-14-2013, 01:02 AM
  2. Replies: 1
    Last Post: 12-04-2012, 05:30 PM
  3. Concatenate array string
    By tushar.tarafdar in forum Excel Help
    Replies: 2
    Last Post: 09-20-2012, 12:00 PM
  4. Replies: 4
    Last Post: 04-07-2011, 07:09 AM
  5. Replies: 6
    Last Post: 04-03-2011, 09:46 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •