RIGHT function not working

J

Jase

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
 
B

bpeltzer

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)
 
Top