formatting macro issue

[George Wilson]

I have recorded a macro that formats a cell, I am unable
to stop recording the macro with the focus on the same
cell. Hitting return I can then stop recording but get a
range statement at the end of the macro. This is what I
have for the macro:

With Selection.Interior
.ColorIndex = 39
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
ActiveCell.FormulaR1C1 = "^"
Range("H27").Select

This causes the macro to end o up on the H27 cel after
every time the macro is run. Is there any way to keep the
focus on the active cell I start from?
Thanks for any assistance or suggestions...
George

 

[Jezebel]

Delete the 'Range("H27").Select' statement.

BTW, this is a Word forum. You'll get better Excel responses elsewhere.