View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default .Cells(Row,Column) parameters

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