Are the inputs on the same sheet as the outputs, or on a different
sheet ?

dim i,x

for 1=1 to 100






Tim

On Feb 8, 2:30*pm, "Mike L." wrote:
I have two inputs
C2 and G2

that go through a complex blue printing system to generate a bunch of
values, call them

'sheet2'!a4
'sheet2'!b6

and a bunch more.

I want to write *a macro that will get the outputs from a4 and b6 for
a range of 1 to 100 for c2 and 1 to 100 for g2 and display it on two
columns

C2 | G2 | output from a4 | output from b6 |
*1 * * 1 * * * * *ouput1 * * * * * * * * output1
*1 * * 2 * * * * *output2 * * * * * * * * output2
...
100 *100 * * * output9999 * * * * * output9999