View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
curious curious is offline
external usenet poster
 
Posts: 1
Default VBA passing vector from spreadsheet to array

Hi all,


What is the proper way (best way) how to pass date vector fro
spreadsheet to a date vector inside VBA?


Ideally I would like to have something like this:



Code
-------------------

Public Function foo(inputVector() As Date)

Dim firstDate As Date
firstDate=inputVector(1)

...

End Function

-------------------



but this does not work.

Thanks

--
Message posted from http://www.ExcelForum.com