Iterate Mutiply&Devide Operations for Each Row

Hi VBA Gurus:

I need a code to iterate the following tasks on the sheet"Quote Summary" and only.

Pseudo Code:

*This code should ONLY valid on the sheet "Quote Summary"

1, Start from Row 2 on Quote Summary Sheet,
I2=F2*H2
J2=F2*G2
K2=I2/J2

2, Repeat for all of the rows in the sheet Quote Summary


Process Sample 6-Iterate Mutiply&Devide Operations for Each Row.xlsm

Thank you and I am looking forward to your response,

Chris

Try the attached.

Thank you so much for your codes!

They all works very well!

Chris

Well Actually there is a problem.

Would you modify your code a little bit so that Ki=Ii/Ji works only when Ji >0, if Ji<=0, just leave Ki empty.

Thank you,

Chris

Chris,
My code has already incorporated that line. It is less than 0, it returns 0.

Hello AB33:

Not sure why but I could not run your code on my original workbook.

Also it seems need to Dim parameters as I put this code into a group of other codes within the same module. And the module starts with Option Explicit.

Chris,
Please see attached.
I normally use Option Explicit as default set up on my codes.
It forces you to declare all variables used on that module and can correct errors. There are no variables on the attached. You can remove it on this code as it would not make any difference

Originally Posted by AB33

Chris,
Please see attached.
I normally use Option Explicit as default set up on my codes.
It forces you to declare all variables used on that module and can correct errors. There are no variables on the attached. You can remove it on this code as it would not make any difference

Hello ABB33:

I appreciate your response. The program finally worked. Worked very well with other codes in the same module actually.

Thank you again for your response!

Chris

Originally Posted by TMS

Please Login or Register  to view this content.

Regards, TMS

Dear TMS:

Thanks for your response!

Just saved this on into my"code library" for future reference.

Thanks again and have a wonderful one!

Chris

@Richard Buttrey

Thanks for letting me know!

Chris