View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default R1C1 type refences in VBA for column identification

another road to Rome..
Activesheet.Columns(1).Resize(,3).Select

keepITcool

JWolf wrote:
Range(Columns(1), Columns(3)).Select
John R. Reagan wrote:
would look something like Columns( x & ":" & y).select.