Reducing 2 spaces, down to 1

[Tywardreath_NZ]

Hi

I am a VBA novice, and would appreciate your help trying to get a solution to my problem. I would like to remove all double spaces, and replace them with a single space within a worksheet (or just column B). The code needs to repeat until there are no more double spaces left.

What I have so far is this:

Please Login or Register  to view this content.

The problem is I get a run-time error '94', and I really don't know how to fix it. Can anyone help?

Thanks in advance.

[shg]

Select a range of cells and run this:

Please Login or Register  to view this content.

[Trebor76]

Hi there,

The following should do the job for cells B2 to B[lngLastRow]:

Please Login or Register  to view this content.

HTH

Robert

[Tywardreath_NZ]

Thanks so much. Both pieces of code work really well.

Thanks again.

[Trebor76]

You're welcome. Please ensure you mark the thread as [SOLVED]