Thread: Outputting the contents of an array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TommySzalapski[_20_] TommySzalapski[_20_] is offline
external usenet poster
  
Posts: 1
Default Outputting the contents of an array

Try something like

Dim strNums As String

strNums = CStr(TNum(1))

For i = 2 to j ' assuming j is the number of elements in the array

strNums = strNums & ", " & CStr(TNum(i))

Next i

MsgBox(strNums)

'CStr converts the number to a string


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=390757

Reply With QuoteReply With Quote