Hi,
I still can't figure out how to pass arrays to and from functions. Can anyone help me?
I want to create a two-dimensional array in one function, then pass it to another function. This code, is working fine:
However, If I try to separate this out into seperate functions, it doesn't work:
Please Login or Register to view this content.
Can someone please tell me what I'm doing wrong? Many thanks!Please Login or Register to view this content.
One way:
(See attachment for code; the forum isn't cooperating)
OneTwoThree B1: =ReplaceDigits(A1)
See VBA Help for Understanding Scope and Visibility
Entia non sunt multiplicanda sine necessitate
@Monkihunta :
@shg :Please Login or Register to view this content.
The forum dislike the "Replace" function ( "Replace" word immediately followed by "(" ), so, use the Replace$() function instead (if the expected return datatype is string).
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks