+ Reply to Thread
Results 1 to 4 of 4

VBA Array Function Error

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Question VBA Array Function Error

    Hi All,

    I am trying to use the attached function codes which gives me an error in Excel VBA.

    Even I tried to use it inside Replace function but I am unable to get it below 255 characters.

    Any suggestions.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: VBA Array Function Error

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: VBA Array Function Error

    create names for parts of your formula

  4. #4
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: VBA Array Function Error

    This is my working array function direct in excel, why cannot I just use it as it in VBA :

    HTML Code: 

+ 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. [SOLVED] MAX function not working on array with error values
    By funkyman1969 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-21-2017, 04:56 AM
  2. Keep getting an error when trying to return array from function
    By cosmicwinds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2016, 12:41 AM
  3. [SOLVED] #DIV/0! error for an array function
    By macrorookie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2014, 09:08 AM
  4. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  5. Copy two array: Function RtlMoveMemory() in Excel 64-bit is error?
    By tuanktcdcn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2013, 02:44 PM
  6. RANK function and Array Formula Error
    By Sparky12 in forum Excel General
    Replies: 4
    Last Post: 02-28-2009, 05:46 PM
  7. #DIV/0! error in Average If Array function
    By ren1104 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-28-2007, 02:24 PM

Tags for this Thread

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