In VB can the Column parameter in .Cells(Row,Column) be expressed in
numerical format to signify an area of contiguous columns. If so, what is the
expression format. I would like to express Columns 4 thru 21 without using a
do-loop.

Bob Carter
Douglas, MA
USA

Do something like:
Range(Cells(Row,4),Cells(Row,21))
HTH Otto
"Trebor Retrac" wrote in message
...
In VB can the Column parameter in .Cells(Row,Column) be expressed in
numerical format to signify an area of contiguous columns. If so, what is
the
expression format. I would like to express Columns 4 thru 21 without using
a
do-loop.

Bob Carter
Douglas, MA
USA

or

Cells(Row,4).Resize(,10)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Otto Moehrbach" wrote in message
...
Do something like:
Range(Cells(Row,4),Cells(Row,21))
HTH Otto
"Trebor Retrac" wrote in message
...
In VB can the Column parameter in .Cells(Row,Column) be expressed in
numerical format to signify an area of contiguous columns. If so, what
is
the
expression format. I would like to express Columns 4 thru 21 without
using
a
do-loop.

Bob Carter
Douglas, MA
USA

Thank You both Otto and Bob.
Bob Carter