Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlFillFormat to Right
How do I use xlFillFormat for 9 columns to the right of my current Column
(which is Column A)? I have this code: ActiveCell.Resize(, 9).Select Selection.AutoFill Destination:=.Range(.Cells(, 9), Type:=xlFillFormats The second line is failing. Please help! Thanks! Ryan--- -- RyGuy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlFillFormat to Right
maybe this:
Sub test() With ActiveCell ..AutoFill Destination:=.Resize(, 9), Type:=xlFillFormats End With End Sub -- Gary "ryguy7272" wrote in message ... How do I use xlFillFormat for 9 columns to the right of my current Column (which is Column A)? I have this code: ActiveCell.Resize(, 9).Select Selection.AutoFill Destination:=.Range(.Cells(, 9), Type:=xlFillFormats The second line is failing. Please help! Thanks! Ryan--- -- RyGuy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|