Thread: right
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default right

Thank You




-----Original Message-----
Hi;

You can use
MyRightOfTheFormula = Right(ActiveCell.Formula, 3)

Thanks,

Greg
-----Original Message-----
Hello,

Is it possible to tell what the right 3 characters in a
formula are

I am familiar with =Right(a1,3)

but how do I get this to work with the formula in the

cell
not the value that ends up in the cell
.

.