How to simplify code?

**RaquelAR** · 11-27-2013, 08:46 PM

Hi, guys!

My userform freezes randomly when I press the button that contains an apparently "complicated" code.

Please Login or Register  to view this content.

Anyone knows how to make the simplier so it doesn't freeze randomly? Thank you for reading

**Norie** · 11-28-2013, 05:27 AM

Simplifying the code won't necessaryily stop it freezing.

You need to find out why it's freezing.

The first thing you should do to help with that is remove On Error Resume Next, that could just be hiding problems.

**RaquelAR** · 11-28-2013, 06:29 AM

Originally Posted by Norie

Simplifying the code won't necessaryily stop it freezing.

You need to find out why it's freezing.

The first thing you should do to help with that is remove On Error Resume Next, that could just be hiding problems.

Thank you for your help

The error handler is essential as I have 7 subcats and 6 periods, it will always give me an error there.

The matter is that when I push the button it runs the whole code fine for X number of times and then it could freeze or it could just run fine everytime I push the button. It's really random.

I've run the code on F8 and the merge thing is the part that is actually time consuming.

**Norie** · 11-28-2013, 07:30 AM

What errors do you need to handle?

Perhaps they can be dealt with without using an all encompassing On Error... statement which will hide, sorry I mean cover, every error in the code.