mardi 21 novembre 2017

VBA: Next without FOR error

I have built a VBA macro on excel where I run several IF's inside a For. If I brake the ifs in different packs of for, it works fine, but it runs through all my lines more times (the amount of packs) than necessary and it becomes slow.

If I try to do all the ifs inside one for, it wont compile and gives me a 'next without for' error.

Do you know if there is a size restriction on the code inside a for?

Thanks

Aucun commentaire:

Enregistrer un commentaire