I have the below code which is working quite well. I'm wanting it to only be changing the colours from a range of the shapes I have on the sheet, not them all. Any idea how to do this?
VBA Code:
Sub SetColor(v)
Dim cell As String
cell = ActiveCell.Address
ActiveSheet.Shapes.SelectAll
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(175, 171, 171)
ActiveSheet.Shapes(v).Fill.ForeColor.RGB = RGB(224, 255, 124)
Range(cell).Activate
End Sub