Leading or trailing spaces code failing randomly

Dear Experts,

I used the code below in cleaning out "leading or trailing" spaces in any workbook (saw the code on one of the excel forums, cant remember which) that i am working on. However lately, i discovered that it just fails for no reason and some days it will work without issues.

Can anybody help spot what could be wrong with this code? or help with another code that works.

Please Login or Register  to view this content.

Note: The above code cleans out my Sheet(s) instantly and i don't have to loop (I have a big data set). That is why i am partial to it and want it to work

See attached NeedForExcel

Capture.JPG

Note: wksPT is defined as a worksheet..

Thanks Kaper for the snippets.. They both worked and i like the shorter version better

Not really NeedforExcel. However, i will go with Kaper's code and i give Jindon's code a twirl from the link below (Saw the code some mins ago).

http://www.excelforum.com/excel-prog...ve-spaces.html

Thanks for your help and time Kaper and NeedForExcel.. Much appreciated!