Strange effect trying to insert new line

[FoxIII]

I currently have a macro that, when a user clicks on a button, inserts a new line enabling the user to enter further information.

Now, the problem is that if I click the button to run the macro, or run the macro via the menu, a new line is inserted, but below the one the user is on.

If I go into VB and 'step' through the macro, then the line is inserted 'above' the one that the user is on which is what I want.

The macro I am using is;

Please Login or Register  to view this content.

It's one of those things that I can't for the life of me work out what's going wrong where.

[sweep]

Hi,

The code you've attached will always insert a row at row number 7.

To insert a row above the row of the currently selected cell, try this.

Please Login or Register  to view this content.

[FoxIII]

I don't think I explained it well enough :s

When the user clicks 'add new line', a new blank line is inserted at row 7 which moves the current line down to row 8.

What I have and I tried your code to, just creates a new line after row 7. I can't move one row up and use the code to copy it, as this is the titles and has a different setup.

[sweep]

What do you want to happen exactly?

The user clicks a button and it adds a new line below row 7 and moves everything else down? Or it adds a new line where the cell is selected?

[FoxIII]

A user will complete row 7 with the relevant information. When they want a new blank line to complete another row, I want row 7 (the already completed row) to move down a row (to row 8) and a new row to be inserted at row 7.

The user will then always be inserting their information in row 7 and the previous information will be shifted down. Part of the information is a date, so this will be in descending order.

Ex.

Row 7: 01/01/09 Description 1 £30.00

after clicking on an 'Add New Line' button...

Row 7: 02/02/09 Description 2 £25.00
Row 8: 01/01/09 Description 1 £30.00

I hope I've managed to explain that better this time.

[sweep]

OK, understood!

I can't get this:

Please Login or Register  to view this content.

to do anything other than insert a blank row at row 7 and move the previous down.

Please let me know how it works out for you?

[FoxIII]

Yes! Thank you sweep, that works exactly as I wanted :D