+ Reply to Thread
Results 1 to 2 of 2

Code to determine if a cell contains an array function?

  1. #1

    Code to determine if a cell contains an array function?

    I am looking for ways to reduce filesize and overhead in a large
    spreadsheet, and as part of that I'm looking for alternatives to array
    functions. I wrote this code thinking I could determine when an array
    function occurs:

    Dim rCell As Range
    For Each rCell In ActiveSheet.UsedRange
    If rCell.FormulaArray = True Then
    MsgBox rCell.Address
    End If
    Next rCell

    .... but this seems to find a cell that is part of an array. Can anyone
    suggest some better code to determine if a cell contains an array
    function?

    Thanks


  2. #2
    Dave O
    Guest

    Re: Code to determine if a cell contains an array function?

    Try
    If rcell.HasArray = true then

    .... instead.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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