Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting up input box, and column row calls
Hello all.
I have made an auto fill macro that I have multiple cell inputs. It's essentially a 3 row, 6 column set. I've made two input boxes. the first is for the row placement, and the second is for the column placement. I would like to use this for the input of each cell's data. My attempt however has not worked. It gets hung up with what I'm thinking is the way I've stated the range values to start. Dim Nu as integer Nu = inputbox (prompt,title) 'row Dim Nu1 as integer Nu1 = inputbox(prompt, title) 'column Range("Nu & Nu1:(Nu & Nu1)+6 & Nu1").Select While I'm certain that I did this wrong, I'm unable to identify the way I should state it. Any ideas on how this should be stated? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting up input box, and column row calls
Hello
I think it's this what you is looking for: Range(Cells(Nu, Nu1), Cells(Nu + 6, Nu1)).Select Regards, Per "SteveDB1" skrev i meddelelsen ... Hello all. I have made an auto fill macro that I have multiple cell inputs. It's essentially a 3 row, 6 column set. I've made two input boxes. the first is for the row placement, and the second is for the column placement. I would like to use this for the input of each cell's data. My attempt however has not worked. It gets hung up with what I'm thinking is the way I've stated the range values to start. Dim Nu as integer Nu = inputbox (prompt,title) 'row Dim Nu1 as integer Nu1 = inputbox(prompt, title) 'column Range("Nu & Nu1:(Nu & Nu1)+6 & Nu1").Select While I'm certain that I did this wrong, I'm unable to identify the way I should state it. Any ideas on how this should be stated? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting up input box, and column row calls
Per,
Awesome. It works perfectly. Thank you. "Per Jessen" wrote: Hello I think it's this what you is looking for: Range(Cells(Nu, Nu1), Cells(Nu + 6, Nu1)).Select Regards, Per |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting up conditional text input | Excel Discussion (Misc queries) | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
Calculating Column and off setting calculated value to another column | Excel Programming | |||
Break Scheduling based on Input of Calls Volume | Excel Programming | |||
Setting up a form to input into selected worksheet | Excel Discussion (Misc queries) |