LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default passing arrays between functions in VBA

Only a variant can be assigned an array - however, there usually is no need
to assign it if you pass it through the arguments of the function - but
since you are giving it a new name, I assume you are assigning it.

I would advise against calling your array "Array" since this is a keyword.
--
Regards,
Tom Ogilvy

"goltinfron" wrote in message
...
Ok, this may sound stupid, but, I have a program where I call in a nxm

array, I will call it array0. That array is then sent to another function,
and comes back, I'll call it array1. I then use try to use array1 in another
function, but I get an error message. Do I need to redefine array1 as a
variant before I use in another function?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Functions/arrays LLama Excel Discussion (Misc queries) 3 July 11th 07 10:23 AM
passing arrays to user defined functions ramki Excel Worksheet Functions 2 February 15th 06 08:34 AM
Passing parameters between functions Gaston[_7_] Excel Programming 4 February 9th 04 04:08 AM
Passing Parameters to Userdefined Functions Peter M[_3_] Excel Programming 3 December 13th 03 07:56 PM
Passing arrays to a subroutine Braden Craig Excel Programming 4 August 17th 03 05:54 PM


All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"