My problem with that is that I need to insert the formula with VBA and make
it so that my users only click a few buttons--they shouldn't even touch the
formula. The column will always be B, but the starting row will change. I
just wish there was a way to tell it to use the active cell.

"arno" wrote:

Hi,

If the
initial starting place for the range was B42, it appears to stay at
B42 even
when I use fill down

that's clear. Use B42 instead of a name if you want it to be flexible
when copying the formula.

arno