Hi,
I have this very simple macro:
Sheets("adjustment").Select
Range("B9:J25").Select
Application.CutCopyMode = False
Selection.ClearContents
Before I run this macro the following things are happening:
- datas are pasted into a different sheet
- these datas are copied into B9:J25
When the destination area contains data then this macro freezes Excel.
If there are no data then it runs "smoothly" :) (It also runs when I
put data manually into those cells)
What should I do to make this macro work?
Thanks,
Laszlo
--
bokodilaszlo
------------------------------------------------------------------------
bokodilaszlo's Profile:
http://www.excelforum.com/member.php...o&userid=32250
View this thread:
http://www.excelforum.com/showthread...hreadid=520012