Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
I am trying to simply put a border around a cell. I'm not sure if this is the right way to go about doing it, but this is the line of code I'm using:
I get an error in the VBA compilor with "colorindex" ... Expected: named parameter.
What must I do to correct the error? I would like to use an RGB value instead of a color index. How would that be done?
Code:
.Cells(dcomprow, 2).borderaround _
Linestyle:=xlcontinuous, Weight:=xlThin, colorindex = 3
I get an error in the VBA compilor with "colorindex" ... Expected: named parameter.
What must I do to correct the error? I would like to use an RGB value instead of a color index. How would that be done?