RIGHT function not working
 

I am trying to use thr ight function but it's not giving me the correct
feedback. In my cell it says "time of day" so I enter this code to look up
just "day" it outputs "time of day"

Sheets("Basis").Range(Right("B42", 3)).Value

any ideas?

thanks,

Jase

RIGHT function not working
 

Working from inside out, Right("B42",3) is B42. So Range("B42").Value is
"time of day". You want to apply Right to the value, not the cell address:
RIgnt(Sheets("Basis").Range("B42").Value,3)

"Jase" wrote:

I am trying to use thr ight function but it's not giving me the correct
feedback. In my cell it says "time of day" so I enter this code to look up
just "day" it outputs "time of day"

Sheets("Basis").Range(Right("B42", 3)).Value

any ideas?

thanks,

Jase