Me again, palups. This is a question for the Excel Programming forum; this
one's dedicated to worksheet functions. If you've never written a macro
before and you'd rather learn how to program in VBA than just have the code
handed to you, drop me a line via email and I'll tutor you a little.

--- "palups" wrote:
Hello there im looking for a macro or formula that will fill all empty cell
from A1 to A1020 with "0" without affecting the blank cell properties i.e.
colors, sizes, etc. Thank you!