Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

can you call an array with a variable name

Status
Not open for further replies.
jrice174

jrice174

Civil/Environmental
Nov 8, 2004
129
If I am making a sub or function to perform a task with an array, can I call the array with a generic name so I don't have to rewrite the routine for each different array name? Forinstance, if I had ArrayA and ArrayB and wanted to change the first instance in each array to 4

strArrayName = "ArrayA"
Call ArrayRoutine
strArrayName = "ArrayB"
Call ArrayRoutine

sub ArrayRoutine()
strArrayName(0) = 4
end sub
 
Replies continue below

Recommended for you

Sort by date Sort by votes
You can do indrect addressing in VB, either by creating Shell Script objects or by using the Eval function. However, based on your situation, it seems far simpler to pass the array as a parameter by reference.

Call ArrayRoutine (ArrayA)
Call ArrayRoutine (ArrayB)

Sub ArrayRoutine (TheArray)
TheArray(0) = 4
End Sub



Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
Upvote 0 Downvote
Thanks so much for the tip. I'm constantly amazed at how a problem that seems so hard at the time can have such a simple solution.
 
Upvote 0 Downvote
I thought I had it, but I still can't make it work. I'm using VBA within AutoCAD but I don't think that makes a difference. I get an error message that says ArrayA is not defined. Should it be a double like the array, a string because it's a name or something else? Do I need to use the Set keyword?
 
Upvote 0 Downvote
I'm sorry, the actual syntax would be as follows:

Dim ArrayA(5) As Integer
Dim ArrayB(5) as Integer

Call ProcArray(ArrayA())
Call ProcArray(Arrayb())

---

Sub ProcArray(TheArray() As Integer)
End Sub

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
Upvote 0 Downvote
That's beautiful.Thanks It worked perfectly.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JoelTXCive
  • Locked
  • Question
Sending an Array into an Excel VBA function and Also Getting an Array Out 1
Replies
6
Views
1K
IDS
IDS
blackeng1660
  • Locked
  • Question
Error macro which multiple coincidence assemblies fastly
Replies
0
Views
827
blackeng1660
blackeng1660
JoelTXCive
  • Locked
  • Question
Excel Named Ranges and VBA 1
Replies
3
Views
1K
IDS
IDS
rotw
  • Locked
  • Question
Sending Visual Basic Output Window (Program Output) to a Form (Text Box) or File
Replies
11
Views
1K
rotw
rotw
EngProgrammer
  • Locked
  • Question
Help with multiple DLLs
Replies
2
Views
960
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top Bottom