View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Inserting Rows with the change event active

Hi KobusD,

It might help if you posted the problematic code.


---
Regards,
Norman



"KobusD" wrote in message
ups.com...
Is there a similar statement as "If Application.CutCopyMode 0 Then
Exit Sub" that I can use in a worksheet change event to allow the
inserting of rows? (the program freezes)

I pressume that the problem occurs due to the fact that the program
'finds it difficult' to establish the TARGET cell. So maybe a way to
eliminate this parameter??