ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inserting rows incrementally using a macros button (https://www.excelbanter.com/excel-programming/412337-re-inserting-rows-incrementally-using-macros-button.html)

Nick Evans

Inserting rows incrementally using a macros button
 
What I meant is

I have 4 employees displayed per week and 52 weekly charts. there is one
line in bewtween each week chart. I need to add a row after the employee on
row 10. When I use the button again I would like to insert the row on row 11,
then 12. This means that any employees added after the current ones will be
underneath each other.

A the moment I have no code for this as I don't know how to write it.

Thanks

merjet

Inserting rows incrementally using a macros button
 
Selection.Offset(1, 0).Insert Shift:=xlDown

Hth,
Merjet



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com