VBA code usinf Right function

[zhead]

I am trying to use the VBA code below and it will work once perfectly the next time all I get is the formula as the results. Does anyone have a suggestion?

Please Login or Register  to view this content.

[Winon]

Hello zhead,

Try:

Please Login or Register  to view this content.

Regards.

[zhead]

Hi Winon,


Thanks. It worked once just like mine. I like that yours is a little neater though.

[Winon]

Hello zhead,

Thanks. It worked once just like mine.

How do you expect it to work more than once? It will change every time you change the Data.


Regards.

[Winon]

Hi zhead,

If you don't want to see the formula use the Code below;

Please Login or Register  to view this content.

Regards.

[zhead]

Winon,

Sorry for the delay been out of pocket for a while. Thanks for all your help. this is what finally worked for me.

Please Login or Register  to view this content.