Help - retrieve cell address

Thank you.

Next question....

How do I substitute r.Value into my range statement below? I essentially want to say from A5 through r.Value


Range("A5:J65000").Select


Thanks Again!