Extracting Comments

Hey guys,

does any one know of a piece of code i can use to copy the comments out of a macro (i.e. all the lines starting with ') and maybe past them into a seperate sheet? i've seen it done in SQL before, but i'm not sure if it's possible here or not...

Wow Thats great Andy, NEver knew that was possible..!