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.

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.

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