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