+ Reply to Thread
Results 1 to 2 of 2

Error on unable to set FormulaArray Property

  1. #1
    Registered User
    Join Date
    06-08-2016
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    54

    Error on unable to set FormulaArray Property

    Please Login or Register  to view this content.
    Why is there error on this whole line? The error says that Run-time error '1004': Unable to set the FormulaArray property of the Range class
    Attached Files Attached Files
    Last edited by Matthewious2016; 08-23-2016 at 10:22 PM. Reason: attach file

  2. #2
    Registered User
    Join Date
    06-08-2016
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    54

    Re: Error on unable to set FormulaArray Property

    Please Login or Register  to view this content.
    I have search for some clues on the internet. Seems like I found that method, but it could not get it working. The error highlight at line ".FormulaArray = FormulaPart1"
    Last edited by Matthewious2016; 08-23-2016 at 10:22 PM.

+ 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. long formula to vba macro - error 1004 unable to set formulaarray property
    By desibabuji in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2013, 06:18 AM
  2. Unable to set the FormulaArray property of the range class
    By BradleyS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2013, 07:57 AM
  3. Unable to set the FormulaArray Property of the Range Class?
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 09:45 AM
  4. unable to set FormulaArray property of Range Class Error
    By BuglerX in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2011, 01:13 PM
  5. unable to set FormulaArray property of Range class Error
    By BuglerX in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2011, 12:14 PM
  6. Unable to set the FormulaArray Property of the Range Class - Error 1004
    By manchmal2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2010, 05:08 PM
  7. Unable to set FormulaArray property of the Range class
    By tempest0123@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2005, 04:05 PM
  8. unable to set the FormulaArray property of the Range class
    By jim kozak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2005, 10:06 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