Reference Specific Cell As Variable?

I have a spread sheet that lists a bunch of dates and expected volume that will be associated with the date. I need to build a macro that will look at the first date expand it out for several months then look at the volume and break that out over a week's time.

That part is simple enough but I need to turn this into a looping statement and I cannot figure out a way to get my macro to always come back to the next date in my list.

Ideally I would like something that is a variable that references the cell I want so I can do something like this.

Code:
MYRANGE = range("B2")
Do
range(MYRANGE).select

[Code]....

This should work for me perfectly if I can just figure out how to make the MYDATE varaible reference a sepecific cell rather than a value or text in the cell.