Hi there,

I am trying to return an array of dates and prices from a worksheet function
and display them starting at the selected item.

This is the function I am using to test. I've seen this done by people such
as Bloomberg but cannot work how to do it at all. Any help would be much
appreciated.

Thanks,

Steve

Public Function ReturnArray() As Variant

Dim tempArray() As String
ReDim tempArray(1, 1)

tempArray(0, 1) = "Price 1"
tempArray(0, 1) = "17/07/2006"
tempArray(1, 0) = "Price 2"
tempArray(1, 1) = "14/07/2006"

ReturnArray = tempArray

End Function