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.