| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating array formulaes in macro
Hi all,
I have a simple question... When I create an array formulae, I press Ctrl+Shift+Enter to make it function correctly. My question is if I want to create an array formulae in VB Editor then what code will facilitate me in doing that. REgards Raj |
|
#2
|
|||
|
|||
|
Raj
Use the FormulaArray property, example ActiveCell.FormulaArray = "=SUM(IF(A1:A10=""a"",B1:B10))" -- HTH Bob Phillips "Raj" wrote in message ... Hi all, I have a simple question... When I create an array formulae, I press Ctrl+Shift+Enter to make it function correctly. My question is if I want to create an array formulae in VB Editor then what code will facilitate me in doing that. REgards Raj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a macro in excel | Excel Worksheet Functions | |||
| I need help with creating a special macro . | Excel Worksheet Functions | |||
| Macro to sum array by date | Excel Worksheet Functions | |||
| copy macro assigned buttons in an array | Excel Worksheet Functions | |||
| Creating a macro | Excel Worksheet Functions | |||
Linear Mode
