Filling Empty Cells with Zeroes

I have a macro to extract and sort the data I want from complicated, messy charts used at my job, and it works well except that empty cells in the selected area cause it to miscount the rows and so omit data. Could someone please guide me to a piece of code that would fill any empty cells in a selected area with zeroes? Thanks in advance.

This is the row-counting function that malfunctions when empty cells are present:

Please Login or Register  to view this content.

It might not be what you're looking for, but I'd suggest putting if statements in the problem cells. You would be creating a second table, which copies all nonzero values from the original, and fills the rest with zeroes.

EX: IF(A1<>0,A1,0)

Thank you very much, gentlemen--problem solved.