muzikman69
New Member
- Joined
- Jun 19, 2007
- Messages
- 30
I am trying to create a macro which will perform the F2 + Enter keystroke, to update formatting for cells.
My difficulty is coming in that the macro recorded below had the "1/2/2007" hard coded into it, and when the date changes on the sheet it continues by updating the cells to the above mentioned date. Is there an easy way to have the formating updated for many lines?
Thanks for any help,
Graeme
Sub F2Enter()
'
' F2Enter Macro
' Macro recorded 7/31/2007 by grander
'
' Keyboard Shortcut: Ctrl+f
'
ActiveCell.FormulaR1C1 = "1/2/2007"
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
My difficulty is coming in that the macro recorded below had the "1/2/2007" hard coded into it, and when the date changes on the sheet it continues by updating the cells to the above mentioned date. Is there an easy way to have the formating updated for many lines?
Thanks for any help,
Graeme
Sub F2Enter()
'
' F2Enter Macro
' Macro recorded 7/31/2007 by grander
'
' Keyboard Shortcut: Ctrl+f
'
ActiveCell.FormulaR1C1 = "1/2/2007"
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub