macro with counter ?

as a new member and not so experienced Excell user, I have the following problem.

I want to split up a very large table. Depending on what is in a record(line) I decide to make a split by inserting 2 lines.

On the first line of the table I insert 1 (one) line and in the first cell of that (new) line the value 1 (one) is entered.

With the cursor I move down several lines, there insert 2 lines. In the first cell of the first new line the text END is typed and in the 1st cell of the second new line the value 2.

With the cursor I move down several (number not important!) lines, there insert 2 lines. In the first cell of the first new line the text END is typed and in the 1st cell of the second new line the value 3.

And so on. and the value of the 1st cell in the 2nd new line increases 1.

I am able to create a macro to insert at the position I want, two (2) lines with in the 1th cell of the 1st line the text END. But how to put an increasing value in the 1th cell of the 2nd line, that is the problem!

Who understands my problem and is able to solve it?

Thanks anyway for reading !

Hi, Right Click Sheet Tab, Select "View Code", VB Window appears.
Paste Entire Code in VB Window.
To use the code Right Click any cell within you range of Data (Column selected within range does not matter).
Code will insert Two rows. In first Row column "A" the word "End" will appear.
In the Second Row the index number, of the number of Double rows inserted will appear.

Please Login or Register  to view this content.

Regards Mick