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

[ILM234]

Hi, I am hoping someone can help me with a macro for Excel 2007. I wish to "reverse" the following macro, so that it sends the contents of an entire column (in this case the second column) back to the previous column as Cell Comments, without interfering with the contents of the cells.

Please Login or Register  to view this content.

[Fettertiger]

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.

[ILM234]

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!