| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news  9D7BB53-9B12-4D7E-9D58-(E-Mail Removed)...> 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message > news 9D7BB53-9B12-4D7E-9D58-(E-Mail Removed)...> > 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 > > > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message > news 9D7BB53-9B12-4D7E-9D58-(E-Mail Removed)...> > 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 | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I reference Current Cell when cell isn't the Activecell | VBA2VBZGuy | Microsoft Excel Programming | 3 | 25th Jul 2011 04:58 PM |
| want J1 to reflect the value of a:2:a500 as the cursor enters the | Gordy99 | Microsoft Excel Programming | 1 | 27th Feb 2008 10:42 PM |
| one cell does not reflect a sum | =?Utf-8?B?YmV0dHkgaW4gQ1Q=?= | Microsoft Excel Worksheet Functions | 8 | 18th Sep 2006 02:56 AM |
| one cell does not reflect a sum | =?Utf-8?B?YmV0dHkgaW4gQ1Q=?= | Microsoft Excel Worksheet Functions | 0 | 16th Sep 2006 03:03 PM |
| Re: Cell Data to Reflect Active Cell | Earl Kiosterud | Microsoft Excel Discussion | 0 | 26th Aug 2005 10:35 PM |
