Macro for adding/deleting new lines

[lukaszK]

Dear all!

I would like to help me in one of my problems... It's project to my work, and I have solved 90% of macros myself but with the one I have really big problem. I'm trying to find out how can I write macro for adding and deleting rows - for example:

My worksheet will be used be used by architect. I would like to give him a possibility to add/remove (by buttons) floor in house section in the file. I would like the whole file has been dynamic and everyone can customize it to his/her needs.

Initially, I wanted to use simple:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

But the problem is that if I have 10 rows added and want to remove only one (last one), it's deleting always the second one.

I'm looking for solution, how to remove always the last one?

I would add that rows which I'm adding/deleting has the background color RGB(192, 192, 192). So maybe it can check which row is the last one in the section to add/remove at the end?

I'm attaching example so that you can see the problem...

Example 2013-10-04.xls

I will be extremely grateful for your help!

[lukaszK]

Sorry, I know double posts are in bad taste but really care about your answers...