View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Cell J1 to reflect activecell Row a2:a500

This is sheet code, did you put it in the right place?

"Where do I paste the code that I want to use in my workbook"
http://www.rondebruin.nl/code.htm

--JP



"Gordy99" wrote in message
...
This is the code I put in per Rick R.:
Private Sub worksheet_selectionchange(ByVal target As Range)
Range("j1").Value = Cells(ActiveCell.Row, 1).Value
End Sub

Can't find it on the macro list and I don't see it running. I know I've
done
something wrong. Must have something to do with the name of the worksheet.
Gordy