Why a code that works for a sheet does not work for all?

Imagine we have this table:

http://3.bp.blogspot.com/_gKAnDYGZZUo/TSxxkuHOvUI/AAAAAAAAACc/_mg0dGSoBEg/s1600/example.JPG

Then, we want create a new line between 34 and 35. The new A35 needs to be merged with A30 and A34, because this new property is a "General Properties", not a "properties".

The title "General Properties" is chosen in a combobox; the new value (Clients M, Clients C, Total, etc) is given by a textbox, for example, we want write: "new total".

I created this code to do it to one sheet, that's ok, see:
(where busca is the address of "General Property")

Please Login or Register  to view this content.

However, when I try to put it inside all my code, It doesn't work to all sheets. Instead of it, it just merged from A30 to A38, deleting "properties". What's wrong?

Please Login or Register  to view this content.

It's a bad idea to merge cells.

Try adding an example workbook instead of a link to an image, which doesn't appear to work

I agree with Roy: VBA can't cope with merged ranges.
I do not know what tipo contains

Please Login or Register  to view this content.