I have a sheet with 3 datablocs rows 1 - 9, rows 11 - 19, rows 20 - 29. Not all rows have data, but the data is always in the first rows of the ranges. The lastrows can be empty.
I would like to keep these ranges when a row is cut or added
Now when I cut 2 rows with a macro, lets say, row 3 and 4, the data that started in row 11, is now in row 9. This is not good, it should stayed in row 11
So I wonder if it is possible, that when I cut rows, the same number empty rows is added starting from the last row in the range?
The same when I add a new row with data in a range, when this row is added in the first free row of a range, the ranges total must remain 30 rows.
Because the cut or add is done with VBA, I would like it that this was possible with VBA.