Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill with Column as a variable
I want to autofill a range of cells from row 3 to 9 in a given column just
like this Range("B3").Select Selection.AutoFill Destination:=Range("B3:B9") When I use a variable the autofill returns an "Autofill method of range class failed" error. Need help please Cells(3, LastCol ).Select Selection.AutoFill Destination:=Range(Cells(3, LastCol), Cells(9, LastCol )) Thanks in adavance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill with Column as a variable
Have you tried
Range("B3:B9")= Range("B3") -- HTH, Barb Reinhardt "LuisE" wrote: I want to autofill a range of cells from row 3 to 9 in a given column just like this Range("B3").Select Selection.AutoFill Destination:=Range("B3:B9") When I use a variable the autofill returns an "Autofill method of range class failed" error. Need help please Cells(3, LastCol ).Select Selection.AutoFill Destination:=Range(Cells(3, LastCol), Cells(9, LastCol )) Thanks in adavance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill with Column as a variable
Thanks Barb,
I just tried but it doesn't work. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill with Column as a variable
Have you tried Just
Range("B3:B9").Select |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill with Column as a variable
i usually do something like this:
Sub test() Dim lastcol As Long lastcol = 4 Dim ws As Worksheet Set ws = Worksheets("Sheet1") With ws .Cells(3, lastcol).AutoFill Destination:=.Range(.Cells(3, lastcol), _ .Cells(9, lastcol)) End With End Sub -- Gary "LuisE" wrote in message ... I want to autofill a range of cells from row 3 to 9 in a given column just like this Range("B3").Select Selection.AutoFill Destination:=Range("B3:B9") When I use a variable the autofill returns an "Autofill method of range class failed" error. Need help please Cells(3, LastCol ).Select Selection.AutoFill Destination:=Range(Cells(3, LastCol), Cells(9, LastCol )) Thanks in adavance |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill with Column as a variable
wordwrap!
Sub test() Dim lastcol As Long lastcol = 4 Dim ws As Worksheet Set ws = Worksheets("Sheet1") With ws .Cells(3, lastcol).AutoFill Destination:=.Range(.Cells(3, lastcol),_ .Cells(9, lastcol)) End With End Sub -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i usually do something like this: Sub test() Dim lastcol As Long lastcol = 4 Dim ws As Worksheet Set ws = Worksheets("Sheet1") With ws .Cells(3, lastcol).AutoFill Destination:=.Range(.Cells(3, lastcol), _ .Cells(9, lastcol)) End With End Sub -- Gary "LuisE" wrote in message ... I want to autofill a range of cells from row 3 to 9 in a given column just like this Range("B3").Select Selection.AutoFill Destination:=Range("B3:B9") When I use a variable the autofill returns an "Autofill method of range class failed" error. Need help please Cells(3, LastCol ).Select Selection.AutoFill Destination:=Range(Cells(3, LastCol), Cells(9, LastCol )) Thanks in adavance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill variable lenght column w/ sequential numbers using VBA | Excel Discussion (Misc queries) | |||
Autofill variable range | Excel Programming | |||
variable column numbers for autofill | Excel Programming | |||
Variable Autofill range | Excel Programming | |||
Variable Autofill Range | Excel Programming |