Hi, it will look like this in VBA code:

Range("A6").Select
ActiveCell.FormulaR1C1 = "=MID(RIGHT(R[-5]C,5),2,3)"

It will put
=MID(RIGHT(A1,5),2,3)
to cell A6

I figured it out with the macro recording function.

I hope this is what you've asked for, if not be more specific please.



"geebee" wrote:

hi,

i am trying to figure out how i can have in my VBA to show the value of:
=MID(RIGHT(A1,5),2,3)

where A1 is the cell in the active sheet.

thanks in advance,
geebee