VBA: vlookup and return cell reference

hi,
i am trying to write some code to analyse a weightlifting movement that occurs 3 times.
In particular there is a part of the macro where the user will input the start and end time of the movement using input boxes (to only select relevant data).
I want to then use a vlookup function to search for the start and end times in a range (1 column) in the time range and return the cell reference of these so i can select only these values and either create a graph or do more analysis.
My code for this particular part so far looks like:

Please Login or Register  to view this content.

I would now like the cell references for the start and end times....any ideas as to how to do this? I thought it might be to do with the address function.
Any help much appreciated!!!

Why not just use custom autofilter for times > Start Time & < End Time, use the macro recorder whilst doing so & that will ive you some code to edit.

You don't need to write the criteria to cells