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)