Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell generation from user input question.
I don't know if this is the right forum to be using, however I have a question. I've never done any programming in Excel before but willing to learn if you can point me in the right direction.This might be a simple question that you can help me with right away. Here we go: If a user inputs a Min and Max value, say 1000 & 10000. I would like a column in another sheet to produce cells from 1000 to 10000 in increments of 1000 (or if possible for large ranges, in increments of 10% of the max) -- Thundersixx ------------------------------------------------------------------------ Thundersixx's Profile: http://www.excelforum.com/member.php...o&userid=30556 View this thread: http://www.excelforum.com/showthread...hreadid=502093 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell generation from user input question.
Dim lbound as Long, ubound as Long, inc as Long
Dim i as Long, j as Long lbound = range("A1").value ubound = range("A2").Value inc = Application.Round((ubound - lbound + 1)*.10,0) if inc < 1000 then inc = 1000 End if j = 1 for i = lbound to ubound step inc Worksheets("Sheet2").Cells(j,1) = i j = j + 1 Next there are certainly faster ways to get the data into excel, but this should be a start. -- Regards, Tom Ogilvy "Thundersixx" wrote in message ... I don't know if this is the right forum to be using, however I have a question. I've never done any programming in Excel before but willing to learn if you can point me in the right direction.This might be a simple question that you can help me with right away. Here we go: If a user inputs a Min and Max value, say 1000 & 10000. I would like a column in another sheet to produce cells from 1000 to 10000 in increments of 1000 (or if possible for large ranges, in increments of 10% of the max) -- Thundersixx ------------------------------------------------------------------------ Thundersixx's Profile: http://www.excelforum.com/member.php...o&userid=30556 View this thread: http://www.excelforum.com/showthread...hreadid=502093 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
VBA Question: User Form and input masks | Excel Programming | |||
VBA Question: User Form and input masks | Excel Programming | |||
user input question | Excel Discussion (Misc queries) | |||
User input in cell | Excel Programming |