Add-in for Excel - Populate a range ?

[Franck]

Hi,
Already have several functions which return a single value in the Excel
calling cell. Works Great. (Without any reference to Excel or the
Application Object)

Now, I'm working on a function which will return a two dimensional
array (column1 date, column2 value) and I've got several question :

- How can I know the adress of the calling cell ?
- Which type for the function result ?
- Will I have to use the Application object in order to fill data ?

Does someone got a sample ?

Thks for help.

 

[Charles Maxson]

Not exactly sure what you are trying to do but to your first question

- How can I know the adress of the calling cell ?

use the Caller property w/ Address to get the location of the calling cell:

Function CallMe()
CallMe = Application.Caller.Address
End Function