F2 on active cell?

[teachman]

Hello,

All I want to do is when I move the cursor to a cell, press F2 then add 2 characters.

I tried starting a macro by clicking on the macro icon in the status bar. But, when I put the cursor in a cell with a value already in, like 'fragpct' and press F2 and add the two characters, in this case '_l' the result is: ActiveCell.FormulaR1C1 = "fragpct_1". The value in the cell won't always be 'fragpct'.

Thanks,

George Teachman

 

[steve the fish]

Like this?

Range("F2").Value = Range("F2").Value & "_1"

 

[teachman]

Sorry, I wasn't clear. F2 was not a cell address it was the Function Key F2.

 

[shg]

activecell.value2 = activecell.value2 & "_l"

 

[teachman]

shg,

Worked like a charm!

Thanks,