Excel macro

[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

 

[Peo Sjoblom]

Just edit the macro and remove the last line

With Selection.Interior
.ColorIndex = 39
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
ActiveCell.FormulaR1C1 = "^"

 

[Don Guillett]

just delete(erase) the last line. what is
ActiveCell.FormulaR1C1 = "^"
should be something like
ActiveCell.FormulaR1C1 = "=a1*b1"

 

[George wilson]

I tried commenting it out and get a VBA error and it wants
to debug. Is there any way to keep from getting the error
after removing the line?

 

[Don Guillett]

I just tried the code here and if worked just fine.

 

[Dave Peterson]

If you can't figure out what's going on, you may want to post the current
version of your code.

It's really easy to make a typo and when you get an extra set of eyes (or
hundreds of them), you'll usually get a response.