As I scan down a multi-column, multi-row range, when a certain condition occurs I want to insert a blank row at that point and push the rest of the range down one row. This is equivalent to the Insert Row command, but must work only within the range, not on the entire worksheet. This push-down may happen many times as I scan down the entire range.
So far I have not found a combination of the Insert method or Row or Rows properties, or some other combo of methods and properties that will do this. Is there a relatively simple way to do it, or do I have to individually copy each subsequent row down one row position (via a loop, of course). That's certainly doable, but it seems rather awkward and time consuming when there are hundreds of rows.
Thanks for any words of wisdom on this topic.
Bookmarks