Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB copy formula and auto fill a range
I am adding a formula residing in "Targeting Parameters" into
"DrListWorkCopy" using autofil into a whole column. When I compile the macro, I got an error on the auto fill line saying" autofill method of Range class failed. Would appreciate some help. My Codes: Public Sub CopyFormulaDrListWorkCopy() Dim Target1Wks As Worksheet, Source1Wks As Worksheet Dim MBC As Range Dim LR As Long, FillRange As Range Set Target1Wks = Sheets("DrListWorkCopy") Set Source1Wks = Sheets("Targeting Parameters") With Source1Wks Set MBC = Source1Wks.Range("D59") End With With Target1Wks LR = Range("A65536").End(xlUp).Row Set FillRange = Target1Wks.Range(Cells(3, 12), Cells(LR, 12)) MBC.AutoFill FillRange End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Range Names & Auto Fill | Excel Worksheet Functions | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
Error using Auto Fill of the class range | Excel Programming |