RIGHT function not working

  • Thread starter Thread starter Jase
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min function with an offset 1
VBA summing function 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
I need help with this program written in Visual Basic for Excel 2007. 4
Difference between dates and times 5
Debug Error 7
incorrect output of if formula 6
Adding up total hours worked on employee schedule using various criteria 0

Back
Top