Simplify Excel VB code

**odggi** · 03-16-2009, 05:53 PM

Hello all, I am hoping for someone to examine my code below and advise on how to make it run more efficiently. Thanks in advance.

Please Login or Register  to view this content.

**shg** · 03-16-2009, 06:35 PM

It would help if you'd tell us what you're trying to do.

**dustycrockett** · 03-16-2009, 06:48 PM

Deleted code in red
Added code in blue

Please Login or Register  to view this content.

**odggi** · 03-17-2009, 08:51 AM

The code needs to loop through all the Production Lines (1 to 15) – between the Prod’ Lines is a list of orders (amount of orders varies) I need to programmatically copy a different formula dependent on the Prod’ Line.
So between Prod’1 and Prod’2 will be Formula 1, between Prod’2 & Prod’3 will be formula 2, etc etc.
I hope this makes sense, my VB code works but as I was hoping make it simpler.