View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default best way to express the range "column N to column M"?

I often myself writing algorithms wherein I want to reference "column N to
column M", where N and M are numbers. For example, I want to write:

Columns(N & ":" & M).Clear

Instead, I seem to have to write:

Range(Cells(1,N),Cells(1,M)).EntireColumn.Clear

Is that the best I can do? Or is there a more efficient way to refer a
range of columns by number?

PS: It seem odd that Columns(2) works, and the "quick info" editing tips
shows Columns(RowIndex,ColumnIndex), but Columns(2,3) does not work.