Home |
Search |
Today's Posts |
#1
|
|||
|
|||
array in VBA
Hi all,
A few days ago I saw an answer to a post that showed the VBA equivalent of using an array worksheet formula with ctrl+shift+enter. I forgot to copy that answer for later use, now I can't find it anymore. Anybody who knows what I mean? If so, please tell me where to find the post. Jack Sons The Netherlands |
#3
|
|||
|
|||
Don,
Do I understand it right: Cells("H5").FormulaArray= will do in VBA the same as array entering (with ctrl+shift+enter) a formula in H5? Jack "Don Guillett" schreef in bericht ... try formulaarray= -- Don Guillett SalesAid Software "Jack Sons" wrote in message ... Hi all, A few days ago I saw an answer to a post that showed the VBA equivalent of using an array worksheet formula with ctrl+shift+enter. I forgot to copy that answer for later use, now I can't find it anymore. Anybody who knows what I mean? If so, please tell me where to find the post. Jack Sons The Netherlands |
#4
|
|||
|
|||
Try it and you'll soon see!
Jack Sons wrote: Don, Do I understand it right: Cells("H5").FormulaArray= will do in VBA the same as array entering (with ctrl+shift+enter) a formula in H5? Jack "Don Guillett" schreef in bericht ... try formulaarray= -- Don Guillett SalesAid Software "Jack Sons" wrote in message ... Hi all, A few days ago I saw an answer to a post that showed the VBA equivalent of using an array worksheet formula with ctrl+shift+enter. I forgot to copy that answer for later use, now I can't find it anymore. Anybody who knows what I mean? If so, please tell me where to find the post. Jack Sons The Netherlands -- Dave Peterson |
#5
|
|||
|
|||
Thanks Dave.
Jack. "Dave Peterson" schreef in bericht ... Try it and you'll soon see! Jack Sons wrote: Don, Do I understand it right: Cells("H5").FormulaArray= will do in VBA the same as array entering (with ctrl+shift+enter) a formula in H5? Jack "Don Guillett" schreef in bericht ... try formulaarray= -- Don Guillett SalesAid Software "Jack Sons" wrote in message ... Hi all, A few days ago I saw an answer to a post that showed the VBA equivalent of using an array worksheet formula with ctrl+shift+enter. I forgot to copy that answer for later use, now I can't find it anymore. Anybody who knows what I mean? If so, please tell me where to find the post. Jack Sons The Netherlands -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |