I'm using Excel 2007, and I'm having problems with something that was simple
in Excel 2002. I have three cells in three rows. After I move to the third
cell in the third row, I need to invoke a macro that presses F2, F9, then
ENTER in that same cell. Then I need the macro hit the up arrow once, to go
up one row and back to the cell in the third row. Finally, I need to cut the
resulting contents of the third cell, and paste them into the cell two rows
above it (the cell in row 1). Then I need to move down one row (to the cell
in the second row) and delete the contents from that second cell.

When I record a macro in 2007, it wants to go back to the cells I edited
when I first recorded the macro. I don't want it to do that. In the code
below, specific cells are specified - B3, B4, and B5. Rather than always
running the macro on these three cells, I need it to work on the cell I have
currently selected, as well as the two cells immediately above it. How do I
need to change the code of this macro so it does that?

Thanks,
GwenH

Sub Macro7()
'
' Macro7 Macro
'
' Keyboard Shortcut: Ctrl+a
'
ActiveCell.FormulaR1C1 = "2.1€“1 Control Rod Guide Tube Assembly"
With ActiveCell.Characters(Start:=1, Length:=37).Font
.Name = "Helvetica"
.FontStyle = "Regular"
.Size = 9
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
Range("B5").Select
Selection.Cut
Range("B3").Select
ActiveSheet.Paste
Range("B4").Select
Selection.ClearContents
End Sub