add a target line to a chart

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

Please Login or Register  to view this content.