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

[alex_read]

Rather than calling on the Range("A1").Select method to grab the cell, you can call the Range("A1").Value to grab the cell's text if I understand your question correctly ....