If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to get pointer in new cell on Open?
I want to have the pointer in the next new cell each time I open the
workbook. is there a way to do this? Thanks |
#2
|
|||
|
|||
Hi Jazz
You can do this for example in the workbook open event (user must enabled macro's) to insert the date in a cell every time you open it on a new line in "Sheet2" Private Sub Workbook_Open() Dim lr As Long With Sheets("sheet2") lr = .Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Row .Cells(lr, "A").Value = Date .Cells(lr, "B").Value = Environ$("username") End With End Sub See also http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jazz Drummer" wrote in message ... I want to have the pointer in the next new cell each time I open the workbook. is there a way to do this? Thanks |
#3
|
|||
|
|||
Ron,
Thanks for the info! "Ron de Bruin" wrote: Hi Jazz You can do this for example in the workbook open event (user must enabled macro's) to insert the date in a cell every time you open it on a new line in "Sheet2" Private Sub Workbook_Open() Dim lr As Long With Sheets("sheet2") lr = .Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Row .Cells(lr, "A").Value = Date .Cells(lr, "B").Value = Environ$("username") End With End Sub See also http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jazz Drummer" wrote in message ... I want to have the pointer in the next new cell each time I open the workbook. is there a way to do this? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cell color index comparison | MINAL ZUNKE | New Users | 1 | June 30th, 2005 07:11 AM |
too many cell formats.. can't open the file at all... | Dorian | General Discussion | 2 | September 16th, 2004 11:20 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
IF only.....IF only.... | SmokingMirror | Worksheet Functions | 8 | August 7th, 2004 07:37 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |