Your opinion of Code Cleaner

[Jack-P-Winner]

I am curious, I ran code cleaner on some of my Macros. What are some opinions and your thoughts about code cleaner for VBA?

Is there a way to find out what it finds that is messed up before it finishes? When I run it , it just says done....so how do you know if you had any issues or not?

Thanks

 

[Marc L]

Unnecessary tool, maybe useful for dirty coder …
​

 

[Jack-P-Winner]

appreciate the comment, I just do not like when I can not see what it does "if " it does anything at all

 

[shrivallabha]

It is certainly not used every day and on all codes which is clearly written on Rob Bovey's download page.
http://www.appspro.com/Utilities/CodeCleaner.htm

I have seen (few times) people asking running code cleaner when code breaks as if interrupted by CTRL+BREAK command although there were no breakpoints in the code. Refer to Charles Williams' post in this thread:
http://stackoverflow.com/questions/...y-with-message-code-execution-has-been-halted
Its success rate is not 100% in those cases if you see this post:
http://www.excelforum.com/excel-pro...9941-code-execution-has-been-interrupted.html

So the answer to your question: not all improvements are perceptible to naked eye! Sometimes it is used as last ditch attempt if many other efforts have failed.

Edit: I do not use Code Cleaner. I have not experienced above issue personally.

Hth,

 

[Jack-P-Winner]

Thank you Shrivallabha for all the info, sounds like a big waste of time. I will chug through the info on the links