![]() |
#2
|
||||
|
||||
![]()
A trivial demonstration of using arrays in Word:
Code:
Sub Demo() Application.ScreenUpdating = False Dim MyArray() As String, i As Long, j As Long For i = 10 To 1 Step -1 ReDim Preserve MyArray(j) StrTxt(j) = i: j = j + 1 Next MsgBox UBound(MyArray) ' Count of array elements (0-based) MsgBox Join(MyArray(), ", ") ' Unsorted list of array elements WordBasic.SortArray MyArray() ' Sort the array MsgBox Join(MyArray(), ", ") ' Sorted list of array elements Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Simplifier | Excel | 1 | 09-03-2016 03:50 AM |
Create an input box for arrays | rajani | Word VBA | 2 | 08-17-2015 06:28 AM |
Variable arrays from user input | SeattleITguy | Excel Programming | 1 | 01-29-2015 09:19 AM |
![]() |
ptmuldoon | Word VBA | 3 | 12-13-2014 11:21 AM |
![]() |
JDevsFan | Excel Programming | 4 | 03-15-2012 08:44 AM |