Hi justmegan,

I believe the answer is yes, but would it be possible to see the sheet to understand a little better? You want the range to be every 7th cell in the row, but your range is the range where the name matched... so if you just select every 7th cell, does that not mean you are selecting all surnames?