observation on .filldown method
 

so here I was, using .filldown to fill in a set of
formulas from the top row to the rest of the rows in the
selected range...

but, then I needed it to just put the formulas in a single
row, too...

so, silly me, I just figured the .filldown wouldn't
particularly have anything to do, in that case, when only
one row was selected...

but no, it looks in the row above it and picks out the
constants which are one row ABOVE the selected range, and
stashes them on the current row (even though there are
already exisiting formulas on the current row).

So, I tried it through the edit menu, and sure enough,
Edit-Fill-Down does the same thing... if one row is
selected, it picks data from the row above, no matter what
may already exist in the current row.

but, as far as I can tell, this behavior, which seems
different to me, when one row is selected than when
multiple rows are selected, is not documented anywhere in
the help.

I can get around it wiht an If-End If to skip that line of
code, but does anyone know if this behavior is documented
somewhere and I just haven't found it?