| 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 |
| 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) | |||
Threaded Mode
