Insert Rows

bloubul

Member
Hi All

I'm in search for a macro to insert a new "ROW", but also keep one row open so that the numbers will remain together.

Attached my file, sheet "Current" is how it currently looks, sheet "New" is how it should looks like, the numbers in column B will be from 1 to 52, but I must be able to in increase the numbers to 69.

I thank you in advance.

https://www.mediafire.com/file/30de5u3vs127md0/Insert_Rows.xlsx/file


BlouBul :cool:
 

time*treat

Member
Hi All

I'm in search for a macro to insert a new "ROW", but also keep one row open so that the numbers will remain together.

Attached my file, sheet "Current" is how it currently looks, sheet "New" is how it should looks like, the numbers in column B will be from 1 to 52, but I must be able to in increase the numbers to 69.

I thank you in advance.

https://www.mediafire.com/file/30de5u3vs127md0/Insert_Rows.xlsx/file


BlouBul :cool:

Slightly modified version of what we've done, before.
Since the code works on the same worksheet as the data, you're hosed if you do things wrong.
Added a new page called "Test". Play around on that page to get a feel of how the code works.


http://www.mediafire.com/file/tkm7mzkb9wgxz8k/Insert_Rows.xls/file
 

Sidebar

Top