+ Reply to Thread
Results 1 to 2 of 2

How to enter an array formula?

  1. 10-04-2006, 03:44 PM #1
    pikapika13
    pikapika13 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 10-04-2006, 10:19 PM #2
    Barrie Davidson
    Barrie Davidson is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1