Received: by 10.50.76.133 with SMTP id k5mr1186213igw.2.1332429525254;
        Thu, 22 Mar 2012 08:18:45 -0700 (PDT)
X-BeenThere: exceldna@googlegroups.com
Received: by 10.231.56.140 with SMTP id y12ls3283461ibg.9.gmail; Thu, 22 Mar
 2012 08:18:44 -0700 (PDT)
Received: by 10.50.214.102 with SMTP id nz6mr1178805igc.4.1332429524433;
        Thu, 22 Mar 2012 08:18:44 -0700 (PDT)
Received: by 10.50.213.40 with SMTP id np8msigc;
        Thu, 22 Mar 2012 08:15:22 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.68.240.6 with SMTP id vw6mr1859634pbc.18.1332429320990; Thu,
 22 Mar 2012 08:15:20 -0700 (PDT)
Authentication-Results: ls.google.com; spf=pass (google.com: domain of
 gianka...@gmail.com designates internal as permitted sender)
 smtp.mail=gianka...@gmail.com; dkim=pass
 header...@gmail.com
Received: by pz2g2000pbc.googlegroups.com with HTTP; Thu, 22 Mar 2012 08:15:20
 -0700 (PDT)
Date: Thu, 22 Mar 2012 08:15:20 -0700 (PDT)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
 1.0.3705; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR
 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR
 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E),gzip(gfe)
Message-ID: <01f70ff0-de5e-4442-97f9-9242c80ab193@pz2g2000pbc.googlegroups.com>
Subject: Using the add-in to return and create cell ranges in Excel
From: gotpp <gianka...@gmail.com>
To: Excel-DNA <exceldna@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I was looking at the FinAnSu sample and was working on my own test as
well. Would it be possible to create a function where I type in the
function in one cell (a 1x1 range) in Excel ie. =DrawMatrix(10,20) and
then it will go and create a 10x20 cell range with some data values in
Excel with the top left corner of the matrix as the cell I put my
formula in.

Basically, we don't want an array formula where we have to select an
Excel range, enter our formula, and press Ctrl+Shift+Enter. We want it
to be simple. Type a formula in one cell and render an array or Excel
range relative to this cell.