Friends,

I have a global rng variable, r that is stored as the active cell on selection change. Then I have the following subroutine:

Please Login or Register  to view this content.
The goal is to delete an entire row of data so that the remaining rows will "shift up" to maintain a contiguous sheet. about 60% of the time it works perfectly fine but when it doesn't, I get a "not enough resources to display completely" error and then a "delete property of range class failed" error.

Any idea how I can get around this inconsistency?

Thanks in advance,



-Mike