Building a string and using it as the function array name

Question

I'm not sure how or if I can do this... I want to build the function name using "ap1", which I'm able to do, but I'm getting an "expected array" error. Thoughts? I've been staring at this too long.

Here's the piece of code:

Dim ap As Range
Dim newnum0 As String
Dim ap1 As Variant
Dim strswprog as string
dim strswtype as string


    If strswprog = "Add PORT" Then
         ap1 = strswtype & "_AddPort" 
    For Each ap In newrange
         If ap > 0 Then
              newnum0 = ap
              ap = ap1(newnum0)    'Here's the problem
              ap.Value = newnum0
         End If
    Next ap
    End if

I can't tell what you're trying to do. Right now it says that ap1 isn't an array, which is correct: ap1 is a string. — tigeravatar
– tigeravatar, Commented Sep 4, 2013 at 14:41
The strswtype value is DMS100 and then I'm adding the "_AddPort" onto it so, ap1 = "DMS100_AddPort". I'm sending the newnum0 value to a function called DMS100_AddPort. Is there a way to do that without having to set it up like: ap = DMS100_AddPort(newnum0) to send it to the function? — Mike
– Mike, Commented Sep 4, 2013 at 16:37

tigeravatar · Accepted Answer · 2013-09-04 16:42:02Z

1

From your comment:

The strswtype value is DMS100 and then I'm adding the "_AddPort" onto it so, ap1 = "DMS100_AddPort". I'm sending the newnum0 value to a function called DMS100_AddPort. Is there a way to do that without having to set it up like: ap = DMS100_AddPort(newnum0) to send it to the function?

To do so, use the Application.Run method:

ap = Application.Run(ap1, newnum0)

answered Sep 4, 2013 at 16:42

tigeravatar

26.7k5 gold badges32 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Building a string and using it as the function array name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related