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 " ! "?

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.