Range(Columns(1), Columns(3)).Select

John R. Reagan wrote:

How can you use R1C1 type identification when refering to columns? I would like to replace the statement
Columns("A:C").select with variables (say x and y) but cannot figure out the formating. The new statement
would look something like Columns( x & ":" & y).select.