| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ctrl+shift+enter
Hi,
I have formula ( Array formula) =MATCH(B2&D2&F2,Sheet2!A:A&Sheet2!B:B&Sheet2!C:C,0 ) How Can we use in VBA Application.worksheetfunction.match.......... How should I use same array formula in VBA. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function of Ctrl + Shift + Enter | Excel Discussion (Misc queries) | |||
| What is Ctrl + Shift + Enter ? | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Multiple Criteria Sumif/Sum..tried & failed Ctrl+Shift+Enter, | Excel Discussion (Misc queries) | |||
| ctrl+shift+enter vs enter | Excel Discussion (Misc queries) | |||
Threaded Mode
