Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activity log" . | Excel Programming | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
how can I count if column A="active" and column E="Job" in a list? | Excel Worksheet Functions | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming | |||
How do I split "A1B2" into "A1" and "B2" using text to column fun. | Excel Programming |