Susan( bhhatm)
The destination range must include the start range.
So change the destination range to include D6.
However, in most case you need at least two cells (values) in order to
autofill a range... maybe D5:D6 for the start range and D5:D100
for the destination range?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Susan" wrote in message oups.com...
i'm working on a larger macro & am having trouble w/this section
specifically. i've got it almost done but am getting a "run-time error
1004... autofill method of Range class failed" error........

Startcell.AutoFill Destination:=InsRngTmp, Type:=xlFillDefault

is there something wrong with this line? this is where it keeps
breaking.
"startcell" is the cell where the formula is entered, & then it's
supposed to autofill into "insrngtmp".

Dim Startcell As Range
Dim InsRngTmp As Range
Set InsRngTmp = Worksheets("xx").Range("d7:d100")
Set Startcell = Worksheets("xx").Range("d6")

any ideas would be appreciated.
thanks
susan (banging her head against the monitor)