Inserting rows incrementally using a macros button

[Nick Evans]

I am putting together a timesheet using excel and I wish to include a button
to insert rows for addtional emplyees. However when I use macros to do this
it inserts a row on the original row, how can I get it to always place the
row after the last name on the list which will not always be the same?

 

[Otto Moehrbach]

Always include your code in your post. This will help to resolve your
question. Otto

 

[merjet]

I'm puzzled that you want to insert a row after the last used row on a
sheet. Why not simply select the next row after the last row? The
following will do that.

Sub Macro1()
Dim iLast As Long
iLast = Range("A65536").End(xlUp)
Range("A" & iLast + 1).Select
End Sub

Hth,
Merjet

 

[Nick Evans]

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]

Selection.Offset(1, 0).Insert Shift:=xlDown

Hth,
Merjet