range selection error

hey all,
i am using activeX chcekboxes to determinewhat text will be inserten in a column. I have a macro to insert text (see below) that works. and then a macro tu delete it when the chcekbox gets unticked (see below) that works too. As long as they are separeted. Once i combine them as one code for the chceckbox (see below) i get a range selection error. What am i doing wrong? any suggestions? Many thanks. .xls attached


insert

Please Login or Register  to view this content.

Please Login or Register  to view this content.

combinado

Please Login or Register  to view this content.

Not quite sure what some of the code is meant to do, for example which sheet you are doing this on.

Please Login or Register  to view this content.

Anyway, give this a try.

Please Login or Register  to view this content.