to iterate within selected range and loop

I want to iterate values within various ranges
For eg: I have total of 720 input values.these values should be taken from an input excel sheet. and then calculate the output using the specified formulae. and then write the results to another sheet.

The input values consist of 2 columns containing 720 values in sheet called INPUT. the other input data is obatained through directly entering data in the textbox in userform

i want output values between different ranges of those 720 values.
In sheet1. i want to calculate the values using formulas from o to 720

In sheet2. i want to calculate the values using formulas from 181 to 720 and then 0 to 180 (the output should be in such a sequence)

In sheet3. i want to calculate the values using formulas from 361 to 720 and then 0 to 360 (the output should be in such a sequence)

In sheet4. i want to calculate the values using formulas from 541 to 720 and then 0 to 540 (the output should be in such a sequence)


.I have got the code for calculating the values from o to 720. but im not able to get the particular loop

Please Login or Register  to view this content.