insert 3 rows between data
Ps. I wasn't sure what active range meant, so I looked at column A to find the
last used cell in that column.
Then I used that to determine the range that got the inserted rows.
timdavis100 wrote:
I need a loop statement to insert 3 rows between each row of data in the
active range. For example:
1
2
3
I need 3 rows inserted between 1 and 2, 3 rows inserted between 2 and 3.
Thanks in advance!
--
Dave Peterson
|