Hi,
I have 3 types of files that will sort some aspects, in this example by code of product. The problem is that 2-3 seconds after i run the Macro, Excel crashes and i am unable the use the file....
Can anyone explain me, if there is an error in the code that will cause it to crash Excel?
I would attacht the file but it as more than 1 Mb, and i cant...
Please Login or Register to view this content.
He fleyd,
It is hard to tell without stepping through your code and seeing where the hang happens. Perhaps something simple like changing:
Do Until Sheets(snum).Range("C4").Offset(l, 0).Value = "END"
to
Do Until Sheets(snum).Range("C4").Offset(l, 0).Text= "END"
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I dont really understand anything about VBA or programming. I asked a friend to do that to me and on his computer works good, but not on mine...
However i did what you suggested and it crashes the same... i attacht here a picture, not sure if it will help to identify the problem.screenshot.10.jpg
Here are the steps to figure out which step is crashing your UDF.
Change these two lines of:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
to
' Application.ScreenUpdating = False
' Application.Calculation = xlCalculationManual
This will Rem out the lines so they don't work.
NOW - set a breakpoint in the code by clicking in the left margin of the line:
Sheets.Add After:=Sheets(Sheets.Count)
see http://www.wiseowl.co.uk/blog/s196/breakpoints.htm for an example...
Then run your code and it will stop at the line above and you can then step through your code to see which line hangs. Fix that line and run the code again.
Read this: http://www.cpearson.com/Excel/DebuggingVBA.aspx for more hints on how to find these kinds of problems.
I have tried that and strangely (for me) it worked !! I mean, i run the macro and it didnt crashed at the end...
Before this, the macro crashed Excel 2-3 seconds after it complete the "task", it wasnt during the task. But now it is working and doesnt crash Excel after...
I thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks