Very basic question because I don't know much excel code. The question seems
too basic even for the help file!
I have a VB project where I create a spreadsheet and populate 8 columns and
approx 100 rows.
I want to click on any row in column 1 and then get the value of column 8 in
the same row.
Column 1 is a location name, column 8 is a pointer to an rtf file and I
wish to click on the name and open the rtf file in word.
I have no problem with handling the rtf file I just don't know how to return
the location of the cell which I click.

TIA

Ian B