PPRuNe Forums - View Single Post - Another Excel Question
View Single Post
Old 29th January 2008 | 10:54
  #11 (permalink)  
vindaloo
 
Joined: Sep 2002
Posts: 34
Likes: 0
From: UK
oops, didn't read the question properly - I thought that each day was on a separate sheet, not a separate line.

Anway, here's an example of what you could put in the Workbook code to place the cursor on a field containing today's date:

Private Sub Workbook_Open()
For Each cell In Worksheets("Sheet1").Range("A1:A10").Cells
If cell.Value = Date Then
cell.Select
Exit For
End If
Next cell
End Sub


You'd need to replace the Worksheet Name and the range of cells that contain the dates according to your own workbook.

Vindaloo
vindaloo is offline  
Reply