VBA to trim indent of a cell

[Muktar888]

Hey Guys,

Whats wrong with my code?

I am trying to find every cell in the column range that has a left indent " Cevian Capital Partners Ltd" ; first instance in A4.

Then i want to remove the indent:

Please Login or Register  to view this content.

the 2nd tab is what it should look like.

Thanks in advance.

[Olly]

Try:

Please Login or Register  to view this content.

[CK76]

Please Login or Register  to view this content.

Issue is with your If statement. Left() returns string and you are checking if it is numeric.

Try this.

Please Login or Register  to view this content.