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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks