Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
To enter an array function directly in a spreadsheet you use
Ctrl-Shift-Enter. Obviously, you can't do that when writing VB code. Are array functions accessible from VB. I am trying to use an array function using MATCH and IF to look up a row based on two parameters in different columns. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How should I do this (function or Visual basic) | Excel Worksheet Functions | |||
Call a Visual Basic Function with VLookup | Excel Worksheet Functions | |||
Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
Visual Basic macro to do something that is done trhough an Excel function | Excel Programming |