Trying to reference a different tab/sheet to the current sheet with code on.
Name of the sheet highlighted in yellow text.Private Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Shapes.Range(Array("Dial_1")).Select Selection.ShapeRange.Rotation = "Speedometers".Range("F2").Value * 237 ActiveCell.Select End Sub
Thanks
Bookmarks