Hi there,

Could you please say whether the sequence 10,20,30,40.....in column A will
always be in multiples of 10, or whether you need to choose the multiple?

Regards

Ian
--
Work performed in the spirit of service is worship...Baha'i Writings


"cyzax7 via OfficeKB.com" wrote:

Hello there,

I want to create a form that will allow user to enter the value to be
displayed in the excel sheet.
In details:

- User wil enter:

Start number = 10 == This will be displayed in column A1
End number = 100 == This will be displayed in column A100

Stuff1 = 35 == displayed in column C
Stuff2 = 80 == displayd in column D

- Once the user has finished entering the form, the output in the sheet will
look like this:

A B C D
Row1: 10 35 80
Row2: 20 35 80
Row3: 30 35 80
.
.
.
.
Row100: 100 35 80

So, how to create the macro that will looks this way?
I've tried using the array loop, but it doesn't show like described above.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1