|
|
#4
04-08-2014, 01:06 AM
|
||||
|
||||
This works for me:
Code:
Sub Demo()
Application.ScreenUpdating = False
Dim SArr() As String, i As Long
SArr = Split("The.quick.brown.fox.jumps.over.the.lazy.dog.", ".")
For i = 0 To UBound(SArr)
MsgBox SArr(i)
Next
Application.ScreenUpdating = True
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Signature function not working?
|
prroots | Outlook | 6 | 08-17-2015 07:18 AM |
| Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
|
Wrap Text function not working?
|
mhays | Excel | 1 | 11-21-2012 05:03 PM |
|
Can't get AND function working
|
Scaffold | Excel | 6 | 07-09-2010 01:41 AM |
| My weekday function aint working | FraserKitchell | Excel | 12 | 05-25-2010 04:42 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode