want J1 to reflect the value of a:2:a500 as the cursor enters the

  • Thread starter Thread starter Gordy99
  • Start date Start date
G

Gordy99

want J1 to reflect the value of a:2:a500 as the cursor enters the row
But how?
 
Right click on the sheet tab that you want to react to the change in cursor
location and select view code. Paste the following code...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row >= 2 And Target.Row <= 500 Then
Range("J1").Value = Cells(Target.Row, "A").Value
End If
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

want cell J1 to reflect the location of acitivecell.value 4
Add up cell from sheet 1 to show on sheet 2 5
Cell J1 to reflect activecell Row a2:a500 3
How to Populate Data from a table to another 0
Using J1.value to print single label 4
If Range("J1").Text...Then 2
Duplicating cell values from one sheet to another 3
Open four Wbooks, copy four columns from each to Master Wbook 16

Back
Top