Excel 2007 : Macro to send the cell contents of a column to the previous column as comments.

Hi ILM234,

try this one please:

Please Login or Register  to view this content.

The macro will take all calues from Column B (=ColumnNumber 2) and will copy the information into the comments of Column A

Regards

Theo
_____________
If your are statisfied by the solution provided then PLEASE CLICK THE STAR icon.
If the problem is resolved, pls mark your thread as SOLVED.

Thank you! This works perfectly. You also answered my second question, which was how to apply this macro to other columns? This can easily be done by changing the letters and numbers in line #7 of the above code. Theo, you are a legend! This one is SOLVED!