currently I am making a chart in VBA and I am trying to get a target line. I have a code that works but it uses a range and they are always the same number
is there a way to code it so it just looks at 1 cell so I don't have to have the same number in every cell in the comuln? sorry if this sounds confusing! heres what I have noe




With ChrtSrs3
         .MarkerStyle = xlMarkerStyleNone
         .Name = "Target"
         .Values = Range("R6:R66")
        .XValues = Range(Cells(x, 1), (Cells(Y, 1)))
     End With