Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill columns
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill columns
Selection.AutoFill Destination:=Range("D1").Resize(1, 4).EntireColumn,
Type:=xlFillDefault although, as the source and initial destination are the same why not use Dim myRange As Range Set myRange = Selection.EntireColumn myRange.AutoFill Destination:=myRange.Resize(1, 4).EntireColumn, Type:=xlFillDefault -- HTH RP (remove nothere from the email address if mailing direct) "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill columns
Thanks
"Tom Ogilvy" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill columns
Thanks
"Bob Phillips" wrote in message ... Selection.AutoFill Destination:=Range("D1").Resize(1, 4).EntireColumn, Type:=xlFillDefault although, as the source and initial destination are the same why not use Dim myRange As Range Set myRange = Selection.EntireColumn myRange.AutoFill Destination:=myRange.Resize(1, 4).EntireColumn, Type:=xlFillDefault -- HTH RP (remove nothere from the email address if mailing direct) "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill with different Columns | Excel Discussion (Misc queries) | |||
Autofill columns | Excel Worksheet Functions | |||
Autofill counting up Columns and Rows! | Excel Worksheet Functions | |||
autofill information from rows to columns without using transpose | Excel Discussion (Misc queries) | |||
Autofill across columns | Excel Programming |