Hi

Please could you tell me if possible and how to reference cells in a worksheet and use their contents as part of a loop in a macro.

The code I want to build on is below - (thanks for help to AlphaFrog and Jakobshavn)

Please Login or Register  to view this content.
So in a worksheet there will be two columns

A - Indigenous list of cell references that will receive a pop up comment value so the text for example Dashboard!C20
B - A spreadsheet saved in the same folder named for example changelog.xlsx - 'Trial 1'!C21

The macro retrieves cell contents C21 in the Trial tab in changelog.xlsx and pastes it into a comment in the indigenous spreadsheet tab named Dashboard on cell C21 then it moves down a row and repeats copying contents of B into A etc..

Any help much appreciated,

Regards Runswick