Tag Archives: columns

Excel – VBA to Select Columns in VBA with Numbers instead of Letters

Posted by admin on November 5, 2011 Comments Off on 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