Dim statement for Split array

Jennifer Murphy · #5 02-20-2020, 06:03 AM

Quote:

Originally Posted by macropod

So why not simply pass the RGB value as a long? That's what the code in https://www.msofficeforums.com/148862-post9.html does via:
Const w As Long = RGB(255, 255, 255)
[/CODE]

When I saw this example, I was excited to be able to simplify the macro, but a little embarrassed that I missed it in the other thread. I never knew you could put an expression with a function call in a Const statement. But when I tried it, I got an error that it was an invalid statement. Does it really work?

I was able to get something almost as good to work.

Code:

Dim Blue As Long: Blue = RGB(219, 229, 241)
Dim White As Long: White = RGB(255, 255, 255)

Thank you very much

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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