Reference Row in another workbook with integer variable

Hi,

I need to reference a different workbook in a while loop. Each iteration, PopFive increases by 3, as I want to pull the numbers of every third row. How does the syntax of the line go after the " ! "?

ActiveCell.Formula = _
        "='[Brief Demographics (Modern).s.xlsx]demographics'!Cells(PopFive,10)"

Thank you!

Hello orange2014,

Rmember that a Formula is a Text string. All added values must be concatenated within the existing formula.

This adds the cell address into the formula.

ActiveCell.Formula = _
        "='[Brief Demographics (Modern).s.xlsx]demographics'!" & Cells(PopFive,10).Address &""""