Insert Row Macro

[karvan]

Hi,

I have a couple of follow up questions related to this post...

1) What would the macro to insert two rows instead one row?
2) and is there a way to create a sum up of a column when there is a blank row?

an example:

Original:

1 15
1 20
1 25
2 30
2 40
2 50

After macro:

1 15
1 20
1 25
total 60

2 30
2 40
2 50
total 120

Would really appreciate your help on this.

[TMS]

Please don't tag onto someone else's thread.

If a thread appears to be relevant, provide a link to it.

And please read the forum rules again before you post.

Regards

[TMS]

The moderator split this off from the thread you had tagged on to.

However, as you have now opened a new thread which is being followed up ...

http://www.excelforum.com/excel-prog...-with-sum.html

... this one now constitutes a duplicate thread.

Please mark this thread as Solved.

Regard