| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please add an INTERPOLATE function. For vector or array data. | Excel Worksheet Functions | |||
| Lookup that returns vector(array) | Excel Discussion (Misc queries) | |||
| How do I draw 3D vector arithmetic, showing vector subtraction? | Excel Discussion (Misc queries) | |||
| The # in my vector is absent from my array. Can I make it 0? | Excel Worksheet Functions | |||
| PASSING an array to a sub in VBA | Excel Programming | |||
Threaded Mode
