Subroutine to delete a row on double click gone wild!

[npilcher]

Hi folks:
A while back I came to the list with some code to delete a row in a second worksheet based on a deletion of a row in an active cell. I had some great help and guidance from mikerickson and the resulting code looks like this:

Please Login or Register  to view this content.

Just as an FYI the counters represent the following: dynamiccounter is the number of rows used by a range I have named. staticcounter is set to equal the numeric value of dynamiccounter to start with, and then changes depending on whether the number of rows changes as per the code line: sourcesheet.Range("BB1").Value = dynamiccounter

The subroutine deletes a row where I want it to with ease. It works great.

The problem is a row gats deleted ALSO whenever I type text, or change a font, or do anything....! I am frustrated beyond compare. As far as I am aware I am asking the system to ONLY delete a row if the counters differ in number, and these counters do not change value when a font is changed or when text is written into a cell. They sit quietly to the side doing nothing until one row gets deleted. Only then do the values change and this triggers the deletion in sheet two. So why would a row in sheet two be deleted if I type a word or change a font?

I REALLY could use your help!
Nick

[Norie]

Nick

If you want something to happen when you double click then you should be using the BeforeDoubleClick event, not the change event.

[npilcher]

Hi Norie:
Thanks. Sorry, just realized a dent in my original post and apologies. The double click routine I have works fine. I already have a subroutine to add a row based on a double click on this sheet. It works fine. What I needed was an option to also delete a row in case a user needs to delete a row. That was the code I posted above. So, if a user double clicks and adds a row, but realizes they added a row too many, they need the option to delete it. So I figured I'd let them select the entire row as one would normally, and delete it. And based on that action, the matching row in sheet two would disappear.

My apologies for not being as clear as I could have been.

My problem is whatever I do on a row in sheet one deleted the corresponding row in sheet two, not just if I delete a row and the counter numbers change. All and any help much appreciated,
Nick

[npilcher]

Hi Norie:
Thanks. Sorry, just realized a dent in my original post and apologies. The double click routine I have works fine. I already have a subroutine to add a row based on a double click on this sheet. It works fine. What I needed was an option to also delete a row in case a user needs to delete a row. That was the code I posted above. So, if a user double clicks and adds a row, but realizes they added a row too many, they need the option to delete it. So I figured I'd let them select the entire row as one would normally, and delete it. And based on that action, the matching row in sheet two would disappear.

My apologies for not being as clear as I could have been.

My problem is whatever I do on a row in sheet one deleted the corresponding row in sheet two, not just if I delete a row and the counter numbers change. All and any help much appreciated,
Nick

[npilcher]

Sorry folks - I have just realized the title of this post is incorrect. Please see my reply to Nonie just now for a clearer idea of what to do. Question to moderators: Should I remove the post and post a new one? Sorry - new to this thing....