Excel – VBA to Select Columns in VBA with Numbers instead of Letters
So say you want to select a couple columns through a loop and you need to be able to iterate through columns numerically; so you would need to select a range numerically. Here’s the simple way: Columns(“A:B”).Select Range(Columns(1), Columns(2)).Select