+ Reply to Thread
Results 1 to 2 of 2

VBA formulaarray 255 character limit workaround

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    the moon
    MS-Off Ver
    Excel 2010
    Posts
    9

    VBA formulaarray 255 character limit workaround

    Is there any way to get have VBA enter the following array in a cell even though it is above the 255 character limit?

    =SUM(IF(FREQUENCY(IF((AN2:AN1021<=100)*(AN2:AN1021<>""),ROW(AN2:AN1021)),IF(AN2:AN1021>100,ROW(AN2:AN1021)))>=10,1))

    I tried using a workaround posted here:

    http://dailydoseofexcel.com/archives...rmulas-in-vba/

    but could not get it to work


    Thanks in advance

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: VBA formulaarray 255 character limit workaround

    That formula is only 115 characters long.

    Is the problem perhaps you have not doubled the quotes when wrapping the formula in quotes?

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ 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. Workbooks.opentext and Excel column limit..need workaround
    By enphynity in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 07:58 AM
  2. [SOLVED] Workaround to the 32767 character limit for strings in VBA?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2013, 06:18 AM
  3. Workaround for HYPERLINK argument length limit
    By aboorkuma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 11:20 AM
  4. Workaround needed for 255 character find limit
    By NukedWhale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2009, 04:10 PM
  5. busted workaround for 255 character limit in cells
    By mklapp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2005, 05:05 AM

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