I'd like to create a macro that fills a formula down to the final row that
has any data.

-- Just filling to adjacent cells (e.g. double-clicking on the autofill
button) doesn't work because some of the rows don't have data in the cells
the formula is looking for.
-- I know I can select all the cells below the one I entered the formula in
and hit ctrl-D to fill the formula, but I need this macro to be able to run
no matter how many rows of data are present.
-- I tried filling the fomula all the way past the highest row number I'd
ever thought I'd reach but then (because the formula includes absolute text),
it includes all those blank rows (with just the one bit of absolute text) in
the default print area.

It's not a huge deal to just set the print area after running the macro, I
know, but I'm creating this for the use of many people so I'm trying to make
it as "one-step" as possible. Any ideas?

Thanks!
HH