![]() |
#2
|
||||
|
||||
![]()
If you declare an array, you need to populate it with code like:
Code:
Dim x As Long, y as long Dim BlueLite As String 'Light blue RBG values BlueLite = "219,229,241" '. Dim RGBVals() As Variant 'Array for indivicdual RGB values x = UBound(Split(BlueLite, ",")) ReDim RGBVals(x) For i = 0 To x RGBVals(y) = Split(BlueLite, ",")(y) '. Next
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
FuriousD | Word VBA | 1 | 05-12-2019 04:06 AM |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
Split word file into several PDF using the bookmarks as split positions and name | Fixxxer | Word VBA | 7 | 10-08-2018 01:10 AM |
Split function in Excel (split the screen) | Officer_Bierschnitt | Excel | 1 | 07-05-2017 07:02 AM |
![]() |
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |