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.
|