Replace Blanks Cells with a Value

Macro 52: Replace Blanks Cells with a Value In some analyses, blank cells can cause of all kinds of trouble. They can cause sorting issues, they can prevent proper auto filling, they can cause your pivot tables to apply the Count function instead of the Sum function, and so on. Blanks aren’t always bad, but […]