How to repeat vba code a number of times depending on items in an excel list

Hi everyone,

I'm sure this should be pretty simple however I'm missing a step somewhere think.

I have a list of part numbers in excel which changes (both in length and the parts on it) every month, I have a dynamic range set up to accommodate for this.

For each part number I need to run a series of calculations for which I have written code for but I currently have to manually change the part number in cell k3 and then click to run the macro. I know I should be able to do some sort of loop in vba but I can't work it out.

What I have so far is...

Please Login or Register  to view this content.

Could someone give me a hint as to where I'm going wrong?

Thanks,

Alice

Where are the part numbers listed?

Perhaps

Please Login or Register  to view this content.

Lets take a step back and establish exactly what your code is supposed to accomplish.