ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will fill all blanks down a column with the value just above the
blank range if maybe that will do you....

Vaya con Dios,
Chuck, CABGx3



"C. BROWN" wrote:

I have long columns that i want to fill using the last non-blank cell as the
fill. is there a macro or command that accomplishes that.