I have been using a macro that has lines such as....
Rows(Range("'Data'!A1").Value).EntireRow.Select

Which means select the entire row that is defined in cell A1 of the 'Data' sheet. So if A1 on 'Data' said 2, the macro selects row 2.

I would like to get this so instead of selecting the entire row, it just selects column A. So if A1 on 'Data' said 2, it would select A2.