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
Bookmarks