Run a code for several values

Hello Friends,

Is there any way to run the program with multiple variable inputs and get the multiple corresponding data outputs and save them to Excel.

Example:

(I declare Rows and Columns variable in begining of the program)

Rows=100;

Columns=100;

(When code is run obtain outputs of Price and Energy)

Price=X1

Energy=Y1

I need some way to change the values of Rows and Columns bt 50 Increments (100,150,200,250,300,350......) to obtain the corresponding values of Price and Energy(X1,X2,X3,X4......;Y1,Y2,Y3,Y4........)

I want these to be automatically changing,not manually entering the 50 increment values.

Answer 1

[Stephan]

Sounds like you might be interested in vectorization.

[venkat siddhartha rama]

Hey Stephan,

Vectorization sounds like a solution to deal with in the program for variables. In my case, the declared variables(Rows,Columns) have several complex calculations to find out Price and Energy. I want to create a function I guess to run the program with several Input variables and save the corresponding Output variables without ignoring them.

I am not sure If I have explained clearly or not..Please feel free to respond..