Hi,

I have a problem. I will simplify it thusly. I have two workbooks opened, Book1 and Book2. Book2 is macro enabled. Book1 is not macro enabled. I want to copy a row of cells, each of which contain comments, to another worksheet on Book1. Let's say, my comments are located on A9 to F9 on Sheet1 of Book1. I want to transfer or copy those comments to particular cells on Sheet 2 of Book1. Let's say, G5, L12, D4, D13, P2, B13. 6 transfers altogether. What's the VBA code to do this? I am guessing some sort of for each loop.

Paul Carr