![]() |
#6
|
|||
|
|||
![]()
Jennifer,
wdOrange is a Long variable not a wdColorIndex: Code:
Sub MyRandCharColors() Dim oChr As Range Dim sngRan As Single Dim lngColorNext As Long Dim wdOrange As Long Dim varColors wdOrange = 41215 varColors = Array(wdGreen, wdOrange, wdBlue) Randomize For Each oChr In Selection.Characters sngRan = Rnd() lngColorNext = varColors(Int((UBound(varColors) + 1) * sngRan)) On Error Resume Next oChr.Font.ColorIndex = lngColorNext If Err.Number <> 0 Then oChr.Font.Color = lngColorNext End If Next oChr End Sub |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
![]() |
scrinmemphis | Word | 4 | 06-06-2012 11:50 PM |
![]() |
joatmon | Excel Programming | 1 | 05-30-2012 08:23 PM |
Help with VBA macro - Variable input | sc30317 | Excel Programming | 0 | 08-31-2011 01:00 PM |
Variable fields? | Emalee77 | PowerPoint | 0 | 01-30-2011 05:58 PM |