+ Reply to Thread
Results 1 to 8 of 8

VBA over code over the 225 limit and getting a error when spliting

  1. #1
    Forum Contributor
    Join Date
    09-24-2017
    Location
    Vic Australia
    MS-Off Ver
    Office 365 Apps for enterprise
    Posts
    147

    VBA over code over the 225 limit and getting a error when spliting

    Good Morning

    I very new at VBA

    I trying to set a VBA which is longer then 225 limit

    I got a error Complite error Syntax error after looking on google my code was too big for VBA and the code needed to be split

    I followed a guide and now getting error Unable to set the FormulaArray property of the range class

    I have uploaded a sample sheet the Marco is set to place the array in Sheet Timeslot tracker report Cell M2

    In Columns N and O I have my array working just trying to set a marco as there a lot of set up needed for this sheet i'm stuck at this array my marco name is LongArrayFormula()


    I am running excel 2013 for work


    Any help would be great
    JustinwB
    Attached Files Attached Files
    Last edited by justinwb; 01-19-2019 at 07:58 PM.

  2. #2
    Forum Contributor
    Join Date
    09-24-2017
    Location
    Vic Australia
    MS-Off Ver
    Office 365 Apps for enterprise
    Posts
    147

    Re: VBA over code over the 225 limit and getting a error when spliting

    I have looked around on other forums they don't show how where to do a split with the array

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: VBA over code over the 225 limit and getting a error when spliting

    Post the line of code you need to split
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    09-24-2017
    Location
    Vic Australia
    MS-Off Ver
    Office 365 Apps for enterprise
    Posts
    147

    Re: VBA over code over the 225 limit and getting a error when spliting

    Good morning TMS

    Please Login or Register  to view this content.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: VBA over code over the 225 limit and getting a error when spliting

    OK, sorry it's taken a while to get back to you, been a bit busy. However, I have a solution ... with working out

    Please Login or Register  to view this content.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: VBA over code over the 225 limit and getting a error when spliting

    For reference, I have attached the updated workbook.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    09-24-2017
    Location
    Vic Australia
    MS-Off Ver
    Office 365 Apps for enterprise
    Posts
    147

    Re: VBA over code over the 225 limit and getting a error when spliting

    Good afternoon TMS

    Thank you for all your help and support with letting us know where I have to learn more after reading over your guide

    As I was working with 2 sheets I thought I had to have sheet reference: 'Timeslot Tracker report'!
    And using Name manager to short the path for the other sheet
    I have been using Name Manager for so many of my reporting using 18 of them I did not even think of using it to drop the array to under the 225 limit
    I will place my head in the books to learn more about the below vba

    Please Login or Register  to view this content.
    Thanks again for all your help and advise

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: VBA over code over the 225 limit and getting a error when spliting

    You're welcome. Thanks for the rep.

+ 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. [Help] Error: 8192 Character Limit
    By synergeticink in forum Excel General
    Replies: 1
    Last Post: 03-18-2016, 03:39 PM
  2. Prompt Error Messages if Row exceeded Limit
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-05-2010, 01:31 PM
  3. Text Wrapping Limit Error
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 01-17-2009, 06:07 PM
  4. whats wrong with this spliting cell code
    By TTej in forum Excel General
    Replies: 4
    Last Post: 05-02-2008, 07:03 AM
  5. [SOLVED] IF condition Nesting limit error
    By PKadam in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-22-2006, 11:00 PM
  6. [SOLVED] Copy Sheet Error/Limit
    By miha in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2006, 03:40 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