View Single Post
 
Old 02-19-2020, 09:04 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
It's not apparent why you'd want to go down the array path for RGB values, though, whichever approach you take.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote