If .offset (x,x).value contains then

[FallingDown]

Hi all

How can I get VBA to capture whether the last three characters in col. A contains "ABC"?

If it does it should insert "ABC" in col. C (This is not the problem though, I only need to know how I can capture the "ABC")

Thanks a lot

FD

[NeedForExcel]

You can use Excels =right function along with IF. Why would you want to use VBA?

[JosephP]

you can also use right in vba

Please Login or Register  to view this content.

[FallingDown]

Pefrect, thanks JosepP

@msexcelathome: Because it's part fo a bigger macro, formulas only make more issues