View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SteAXA SteAXA is offline
external usenet poster
 
Posts: 22
Default Array - retrieve certain amount of recods for query

I wish this can help you.

Dim icount, supp As Integer
Dim sStr As String
sStr = ""
For icount = 1 To i
supp = icount Mod 150
If supp = 0 Then
MsgBox sStr
sStr = ""
End If
sStr = sStr & " " & Arr(icount)
Next icount
MsgBox sStr

Bye, Ste'