Hi,

I have a file where there are many cells with comment boxes attached to them. What I am wanting to do is to have a macro that will :-

1. find each comment box
2. cut or copy the contents of the comment box
3. and place the text into a cell in the next column

Is there a way to do this with a macro or do I have to do it manually?

Cheers,
Bernz