View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cirrus cirrus is offline
external usenet poster
 
Posts: 1
Default How do I use an array function in Visual basic .NET?

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.