I know that referencing a fixed column but looping through rows using ThisWorkbook.Worksheets("Sheet1").Range("A" & VariableRow).Value works fine.

Is there an equivalent for looping through columns (and a fixed row)? My instinct was to try ThisWorkbook.Worksheets("Sheet1").Range(VariableColumn & "2").Value but this causes a 1004 runtime error.