Can someone please explain why I'm getting this? I see that the ForeColor is a long integer but I get a Type Mismatch error. So I tried String data type and get the same error.
Sub PartShapesTEST2() Dim s As Shape Dim lngColor As Long Set s = ActiveSheet.Shapes("shpPart1") lngColor = s.Fill.ForeColor s.Fill.ForeColor = lngColorEnd Sub
Should be
s.Fill.ForeColor.RGB = lngColor
even though the color is not in RGB ie. not as in (255, 0, 0)