+ Reply to Thread
Results 1 to 2 of 2

How to enter an array formula?

  1. #1
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106

    How to enter an array formula?

    I apologize in advance. I'm sure there is an easy answer to this, but I can't find it here and my help option is a little screwy.

    How do I make a formula into an array using VB? I know in Excel I press control, shift, and enter.

  2. #2
    Registered User
    Join Date
    11-28-2004
    Posts
    11
    Does something like this answer your question?

    Range("A1:A7").FormulaArray = "=TRANSPOSE(C1:I1)"
    Barrie Davidson
    My Excel Web Page

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

+ 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