show value of formula

[geebee]

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

 

[Bob Phillips]

Msgbox MID$(Range("A1").Value,LEN(Range("A1").Value)-3,3)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rick Rothstein \(MVP - VB\)]

Try...

MsgBox Mid(Right(ActiveSheet.Range("A1"), 5), 2, 3)

Rick

 

[Franz Erhart]

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.