Have a code to clear contents on one of my worksheets and it continually causes excel to freeze and forces me to exit the program. When the button is selected it takes approx. 30-45 seconds to clear the data and then excel freezes up. The code is as follows:
Sub()
Sheets("Sheet1").Range("B2:D16000").ClearContents
End Sub
The data in the range B2:D16000 comes from another macro that copies and pastes values to this sheet. I am also working on the mac 2011 version. Thanks
Hi,
Are there any Sheet Change event macros?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi, not familiar with the mac 2011 version, but would it work better if you tried the following:
Please Login or Register to view this content.
ill try that berlan.
what do you mean by sheet change event macros? Im an excel noob
berlan, froze on me again with the code you suggested and the status bar never appeared either. this is beyond frustrating. this is the only macro that causes the freeze. other macros may take a while to calc but they never shut down excel
Hi,Originally Posted by Phily915
A sheet change event macro is simply a macro that is run whenever you make a change to a particular sheet. If you have any sheet change event macros (see in the VBE for that particular sheet) it will depend what that macro is doing as to whether it's a candidate for your problem.
In the range being cleared are there any conditional formats?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks