| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell J1 to reflect activecell Row a2:a500
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell J1 to reflect activecell Row a2:a500
I put the code into a VBA Sheet with the rest of the code for that workbook.
"JP" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell J1 to reflect activecell Row a2:a500
Thankyou sooooo much.
Gordy "JP" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want J1 to reflect the value of a:2:a500 as the cursor enters the | Excel Programming | |||
| one cell does not reflect a sum | Excel Worksheet Functions | |||
| Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
| Formula won't reflect new cell data | Excel Worksheet Functions | |||
| Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
Linear Mode
