I have an Excel sheet with data like so:
I'm creating a macro that will automatically fill any blank cells in column B with 0 with this code:
With Me.Range("b2", Range("b" & Rows.Count).End(xlUp))
Selection.Value = 0
But doing so can fill in all but the last few rows that are empty.
I can understand why because the range only detects the last cell of the column with data as the end range. But how do I get it to follow through all the way to the end?