Passing a whole set of values of an array to a function

**PaulLag** · 01-28-2012, 07:43 AM

Hello there,

I am trying to solve a problem of this topic.

I am assigning the values to an array,

therefore

Please Login or Register  to view this content.

Subsequently, I'd like to pass all the array values to a function.

I have tried to pass them - the whole set of values - this way

Please Login or Register  to view this content.

and then defining the function as

Please Login or Register  to view this content.

Then I utilize the values to realize a calculation into the same function.

When trying to call the function_A, I get the following error

<<type non correspondent>>

(and the call arr() is highlighted)

Please, could anybody kindly explain me the error I am doing and how could I solve this issue ?

Many thanks

**Steffen Thomsen** · 01-28-2012, 09:17 AM

Try

Please Login or Register  to view this content.

This takes an array into the function

Example

Please Login or Register  to view this content.

**MrReds** · 01-28-2012, 01:48 PM

Hello, this is an interesting post.

Please let me append to this thread to introduce a new variable concerning the thread I was going to write.

How would it work in case of a two or three dimensional array ?

The key point is:

- the function
Public Function function_A(arr As Variant)

- the array
arr = WorksheetFunction.transpose(Sheets(1).Range("A1:A5");Sheets(1).Range("B2:B4"))

Call function_A(arr).

How can I pass to the function the second dimension of the array ?

Thank you very much

**pike** · 01-28-2012, 06:08 PM

Mr Reds

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.