Inability to have 2 x Private Sub Worksheet_Change causing problems...

Hi all,

I have just found a code that fixes a problem I had with users pasting data which ruined the existing format. The code now ensures the paste is 'undone' and 'redone' as paste special. Great

However, this seemingly interferes with my existing coding for inserting rows (as I integrated the above into the existing Private Sub Worksheet_Change). Now when I run it, both codes do what they should, but when processing the first code an error box appears - '"Method 'List' of object '_CommandBarComboBox' failed"

Any ideas to allow both codes to work separately?

Please Login or Register  to view this content.