Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with arrays (I think)
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 C5 is 2, then 3 .... Any help would be greatly appreciated. Thanks Robert -- rbhedal ------------------------------------------------------------------------ rbhedal's Profile: http://www.excelforum.com/member.php...o&userid=28199 View this thread: http://www.excelforum.com/showthread...hreadid=477412 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with arrays (I think)
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(i - 1, 0).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 C5 is 2, then 3 .... Any help would be greatly appreciated. Thanks Robert -- rbhedal ------------------------------------------------------------------------ rbhedal's Profile: http://www.excelforum.com/member.php...o&userid=28199 View this thread: http://www.excelforum.com/showthread...hreadid=477412 |