Indirect reference in VB

[PHodgson]

In a cell I have a formula that calculates a row number based on the selection from 3 list boxes, to select a row number.
The formula is:
=4+(Colleague-1)+((Month-1)*21)+((Year-1)*252)
where Colleague, Month and Year are the results.
Based on the result of the calculation, VB is supposed to select a range from a list on the row number returned by the calculation.
e.g. if Colleage is the 3rd in the list, Month is 2nd, Year is 5th, then the required data is on row 1035 and the macro selects row 1035.
Therefore the Range(......).Select vb statement should indirectly reference based on the the contents on the cell that has the calculation.
How do I do this ? In an Excel workbook or Excel 4macro it would be a simple Indirect statement. What about VB ?
Thanks,

[BrendanJenman]

If you get a solution for this please let me know - I am desparate

Thanks
Brendan
Brendan@campwild.co.uk