RIGHT function in VBA
 

Hello,

How can I invoke RIGHT function within VBA? I just need to extract the last
2 characters in activecell. I've tried
"Application.WorksheetFunction.Right(Activecell,2) " but that RIGHT doesn't
seem to exist.

Thanks a lot.
--
Edmund
(Using Excel XP)

RIGHT function in VBA
 

You don't need to use the worksheet function. The function exists in VBA.
Just use val = right(activell,2).

"Edmund" wrote:

Hello,

How can I invoke RIGHT function within VBA? I just need to extract the last
2 characters in activecell. I've tried
"Application.WorksheetFunction.Right(Activecell,2) " but that RIGHT doesn't
seem to exist.

Thanks a lot.
--
Edmund
(Using Excel XP)