Trying to reference a different tab/sheet to the current sheet with code on.

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
Name of the sheet highlighted in yellow text.

Thanks