Weird problem - sheet change, long calculation time

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
585
WOW, I just found this weird problem in my workbook.

In some cells (they are blank) if I try to paste into them, the paste works, but then the program freezes. If I simply hit delete on the cell, it takes about 1 second to calculate, and then it changes **** sheets all by itself.

Any Ideas
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi Dude,

Any worksheet events code that could be triggered each time you do the paste or delete? Eg Worksheet_Change.
 

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
585
I have code that simply changes sheet (for a button instead of clicking the tab at the bottom)

It must be something to do with my macros but because when I don't enable, i don't have the problem.

Weird
 

Watch MrExcel Video

Forum statistics

Threads
1,118,089
Messages
5,570,152
Members
412,306
Latest member
fabio6
Top