Excel XP & Win XP
I have a variable array that could be ShtArray(a,b,c) or
ShtArray(d,e,f,g,h), etc. The number of elements in the array is also a
variable, as you can see.
In proofing my code I want to find out what array the code selected, so I
used:
MsgBox "ShtArray is: " & ShtArray
which errored out with a "Type Mismatch".
What code would I use to see the elements of the selected array?
I just want to see them at this point. I don't want to do anything with
them.
Thanks for your time. Otto

Hi Otto

You have to create a string with all elements from the array:

Dim MsgString As String
For i = LBound(ShtArray) To UBound(ShtArray)
If MsgString = "" Then
MsgString = ShtArray(i)
Else
MsgString = MsgString & ", " & ShtArray(i)
End If
Next
msg = MsgBox("ShtArray is: " & MsgString)

Regards,
Per

"Otto Moehrbach" <(E-Mail Removed)> skrev i meddelelsen
news:(E-Mail Removed)...
> Excel XP & Win XP
> I have a variable array that could be ShtArray(a,b,c) or
> ShtArray(d,e,f,g,h), etc. The number of elements in the array is also a
> variable, as you can see.
> In proofing my code I want to find out what array the code selected, so I
> used:
> MsgBox "ShtArray is: " & ShtArray
> which errored out with a "Type Mismatch".
> What code would I use to see the elements of the selected array?
> I just want to see them at this point. I don't want to do anything with
> them.
> Thanks for your time. Otto
>

Thank you very much for that. Otto
"Per Jessen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Otto
>
> You have to create a string with all elements from the array:
>
> Dim MsgString As String
> For i = LBound(ShtArray) To UBound(ShtArray)
> If MsgString = "" Then
> MsgString = ShtArray(i)
> Else
> MsgString = MsgString & ", " & ShtArray(i)
> End If
> Next
> msg = MsgBox("ShtArray is: " & MsgString)
>
> Regards,
> Per
>
> "Otto Moehrbach" <(E-Mail Removed)> skrev i meddelelsen
> news:(E-Mail Removed)...
>> Excel XP & Win XP
>> I have a variable array that could be ShtArray(a,b,c) or
>> ShtArray(d,e,f,g,h), etc. The number of elements in the array is also a
>> variable, as you can see.
>> In proofing my code I want to find out what array the code selected, so I
>> used:
>> MsgBox "ShtArray is: " & ShtArray
>> which errored out with a "Type Mismatch".
>> What code would I use to see the elements of the selected array?
>> I just want to see them at this point. I don't want to do anything with
>> them.
>> Thanks for your time. Otto
>>
>