Advertisement
Advertisement


VBA How to display array in message box


Question

VBA

Hi I have been trying create an array then display in a msgbox but keep getting this error:

'Invalid procedure call or argument'

I have used the Join function on another array and it works

Sub rangearray()

Dim array1 As Variant

array1 = Range("a1:z1")

MsgBox Join(array1, vbCrLf)

End Sub
2015/01/23
1
8
1/23/2015 11:38:58 AM