Add any number of empty rows to a
range
This is a sequel to my original post:
Add alternate
empty rows to a range – the coolest method
https://meniporat.blogspot.com/2022/08/add-alternate-empty-rows-to-range.html
After publishing it, I thought:
Why not create a generic solution?
Why add only 1 row? Why not 2 or 3 or more?
So I came up with a Parameterized solution:
Put the desired number of empty rows in one formula.
And lo and behold, you have it, like magic.
Attached are three pictures, demonstrating my generic
solution:
The first, only one empty row
The second, two empty rows
The third, three empty rows.
Enjoy 😊
Pic 1 - Add one empty row
Pic 2 - Add two empty rows
Pic 3 - Add three empty rows
אין תגובות:
הוסף רשומת תגובה