Dim statement for Split array

Jennifer Murphy · #3 02-19-2020, 10:28 PM

Quote:

Originally Posted by macropod

If you declare an array, you need to populate it with code like:

I thought the way to declare a dynamic array was with

Code:

Dim varname() . . .

But this code

Code:

Dim sLiteBlue As String
sLiteBlue = "219,229,241"
Dim RGBVals
RGBVals = Split(sLiteBlue, ",")

results in RGBVals being a 3-element array,

Code:

?rgbvals(0)
219
?rgbvals(1)
229
?rgbvals(2)
241

so that this code gets me the integer RGB value:

Code:

?RGB(RGBVals(0), RGBVals(1), RGBVals(2))
15853019

I don't understand why adding the "()" to the Dim statement causes an error.

Quote:

It's not apparent why you'd want to go down the array path for RGB values, though, whichever approach you take.

Because I want to declare the highlight color as a string ("219,229,241") and then convert it to the integer value:

Code:

Dim sLiteBlue As String
sLiteBlue = "219,229,241"
Dim iLiteBlue As Long
Dim RGBVals As Variant
RGBVals = Split(sLiteBlue, ",")
iLiteBlue = RGB(RGBVals(0), RGBVals(1), RGBVals(2))

If there is a better way to convert sLiteBlue ("219,229,241") to 15853019, I'd be happy to use it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge - split merged documents and rename each split document based on text in header	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
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM