Referencing Row Number From A Range?

i'm trying to set up a way to automatically add data labels to several series on a line chart with each series having data labels from a different row. i have managed to accomplish all of this except the last part. i can't find a way to reference different rows within a range.

let's say your code looked like this

Dim DataRange As Range
Set DataRange = Range("A1" , "Z50")

is there any way to reference a specific row from that?

[Code] .....

What I'm trying to do is expand the range from b1:d1 to something like b1:d100 but then when i get to "For Each SingleCell In FilmList" i can get it so that it's only doing referencing a specific row from that list that i can controlupdate with RowCounter .