Pls Pls Pls pls Help.Urgent ..!!Thanks ALOT!!

[ITboy]

I'm creating arrows dynamically in excel. Whenever I click an arrow, it brings me to another sheet where I would display a certain information. I had a help on this:

   Dim shtTarget As Worksheet 
            Set shtTarget = Sheets("TTview") 
           With Selection 
              'you can find the start and endcell here 
                'highlight the cells in shttarget that need to be selected 
           End With 
            Range("A1").Select 'set the focus of the line 

I want to find the value(NOT THE CELL RANGE BUT THE CONTENTS), that is from where to where it is pointing.I want to put it in the With Selection block(as above).Pls help.(AGAIN NOT THE CELL RANGE,EG ("A2")...I WANT THE CONTENTS OF ("A2"))Thanks