View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nick H[_3_] Nick H[_3_] is offline
external usenet poster
 
Posts: 48
Default What's It Doing?

Hi JP,

Thanks for the fast response. This is a large project with a vast
amount of code - the trouble is I don't know which bit of code might
be causing the problem, hence I thought it best not to post any for
now.

I have tried putting breakpoints on every property procedure within
the classes and at the top of the Sheet_Change event (which I thought
should be firing first.

Like I say, the code ignores all my attempts to Ctrl+Break into break
mode and continues to do whatever it is doing until rows are deleted,
and it then stops at the Sheet_Change event break point.

My guess is that, as well as deleting the Excel rows, it is having to
deal with my clsPortfolioItem objects somehow. This is why I started
by saying I think it is an OOP based problem. I need someone who
understands object oriented programming to give me a steer on what, if
anything, I can do to manage this delay.