Here's an easy one for most of you.
I'm trying to figure out VBA code to loop through the rows in a worksheet named Calc and then delete the entire row if the value in column b is null. I know the first inclination will be to use AutoFilter, and that would be fine, so long as the dates in Column A are not unsorted. They are currently in ascending chronological order.
Just to give a better description of the worksheet. Column A only contains dates. Column B only contains integers, but some dates in column A do not have a corresponding integer in column B. These are the rows I'd like to delete.
Thank You.
I'm trying to figure out VBA code to loop through the rows in a worksheet named Calc and then delete the entire row if the value in column b is null. I know the first inclination will be to use AutoFilter, and that would be fine, so long as the dates in Column A are not unsorted. They are currently in ascending chronological order.
Just to give a better description of the worksheet. Column A only contains dates. Column B only contains integers, but some dates in column A do not have a corresponding integer in column B. These are the rows I'd like to delete.
Thank You.