VBA Macro Causing Excel To Crash - Can it Be More Efficient?

**LoggersAW** · 06-02-2013, 08:29 PM

Hello,

I have a macro that if it is run several times within the tool, will cause excel to crash. The purpose of the code is to filter a sheet (Sheet8) by certain values then paste 5 of the rows into a new sheet (Sheet10) then take out any duplicates from the individual columns, sort column B in ascending order then put the result as the ListFillRange for 5 MS.Forms Boxes on a third sheet (sheet9). Any ideas why this might be crashing excel? Are there efficiencies that could be added?

Thanks!
Sarah

Please Login or Register  to view this content.

**MarvinP** · 06-02-2013, 08:49 PM

Hi Sarah and welcome to the forum,

I'd set a breakpoint in the code and single step through it. You need to look at each step to insure it is doing what you are expecting. If it works correctly then you either have a timing problem when you should insert some "DoEvents" in the code or you aren't releasing enough memory to continue.

Read:
http://www.cpearson.com/Excel/DebuggingVBA.aspx

If that doesn't help at all then you need to post the workbook and we can look at it.

Another possibility is that the code is trying to work outside its scope. See:
http://www.cpearson.com/Excel/Scope.aspx

VBA Macro Causing Excel To Crash - Can it Be More Efficient?

LinkBack

Thread Tools

Rate This Thread

Display

VBA Macro Causing Excel To Crash - Can it Be More Efficient?

Re: VBA Macro Causing Excel To Crash - Can it Be More Efficient?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions