View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default AutoFill columns

NumColumns = 5
Selection.AutoFill Destination:=Columns("D:D").Resize(,NumColumns),
Type:=xlFillDefault

--
Regards,
Tom Ogilvy

"Charlie" wrote in message
...
Is there a way I can specify a starting column and number of columns in

the
following statement:

Selection.AutoFill Destination:=Columns("D:H"), Type:=xlFillDefault

Starting column is D
Number of colums?