You received an answer yesterday when you said you wanted rows.

for column you would just alter the code

Sub abc()
If IsNumeric(Range("A2")) And IsNumeric(Range("B2")) And _
Not IsEmpty(Range("B2")) Then
If CLng(Range("B2")) < 0 Then
For i = 1 To Range("A2") / Range("B2")
Range("C4").Offset(0,i-1).Value = i
Next
End If
End If

End Sub

--
Regards,
Tom Ogilvy


"rbhedal" wrote in
message ...

I have a slight problem that Excel either can not do or I can not enter
the formula correctly. I am asking for your expertise. What I need is
to enter Value A into a cell and then enter Value B into a cell, have
Excel do the division, and then generate a table with that number of
rows. For example, if I enter "20" into cell A2, enter "5" into cell
B2, I need Excel to generate a table in cell C4 that starts at 1 and
then in cell D4 is 2, then 3 ....

If further elaboration is needed, what I am looking for is this. If I
have a distance of say 20 meters & I want to break it into 5 equal
sections. I will enter 20 in cell A2 and enter 5 in cell A3. I want
Excel to realize (from my input of 5) that I want 5 columns. Say I
enter the "code" in cell C5 I want Excel to place a "1" in cell C5, &
in cell D5, place a "2", in D6, place a "3"... until it reaches the
nmber of sections that I asked for. I hope this is clear & I hope that
someone can help.

If you can help, please explain in as basic of terms as possible.

Thank you


--
rbhedal
------------------------------------------------------------------------
rbhedal's Profile:
http://www.excelforum.com/member.php...o&userid=28199
View this thread: http://www.excelforum.com/showthread...hreadid=477787