Macro: insert a row

[Neocon]

Hi all,

I've attached an example of my monthly costsoverview.

For each costscategory there's a commandbutton.
I like to create a macro that insert a row between the last product and the row with total.
For costscategory 100 should that between row 9 and 10.

It's easy to create a macro for just one costscategory:

Private Sub CommandButton1_Click()
Range("B50").End(xlUp).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

End Sub

But in this example there are 4 categories and 4 commandbutton...

Is this possible?

Thanks in advance.

[snb]

Please use code tags (see the forum rules).

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[Neocon]

Well forget my old macro code.... because this one wouldn't work...

then it's just an open question :-)

[arlu1201]

You need to put your code (in your first post) in code tags.

[royUK]

neocon, if you want to use the Forum please read the rules that you agreed to!