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

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