show value of formula
 

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

show value of formula
 

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)

"geebee" (noSPAMs) wrote in message
...
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

show value of formula
 

Try...

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

Rick


"geebee" (noSPAMs) wrote in message
...
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

show value of formula
 

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