Rookie: Can't select row with user input?

[RicoJ]

Hi all,

I am new to Excel and have encounter such problem:

I am trying to prompt the user for rows selection. I am not sure if the variables are set up correctly. I tried with integers but didn't work. Thank you for your help in advance!

The code goes as follow:


Sub Select_row()
Dim leftrow As Variant, rightrow As Variant
leftrow = InputBox("give me your left row")
rightrow = InputBox("Give me your right row")


Range("leftrow:rightrow").Select
End Sub



The error message goes as:


[FONT=&quot]Run-time error '1004':[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Method 'Range' of object '_Global' failed[/FONT]
<attachment></attachment>

 

[JoeMo]

The Inputbox function returns a string so you don't need the quote marks. Assuming you expect the user to enter integer values for the row numbers, try:

Sub Select_row()
Dim leftrow As Variant, rightrow As Variant
leftrow = InputBox("give me your left row")
rightrow = InputBox("Give me your right row")
Rows(leftrow & ":" & rightrow).Select
End Sub

Row numbers increase from top to bottom of an Excel sheet, while column numbers increase from left to right so you variables' terminology is a bit confusing.

 

[My Aswer Is This]

Are your trying to select an entire row?

Like:

Rows(12).Select

Never heard or a right and left row.

 

[RicoJ]

Hi Joe,

It worked! but what is & ":" & as in Rows(toprow & ":" & bottomrow).Select? Thanks!

Rico

 

[JoeMo]

Toprow and bottomrow are already strings b/c they were returned by the Input function. To create the range of rows you want to select they must be separated by a string colon ). The & ":" & does that. The & acts like the + sign in adding numbers together, but it joins 2 strings instead. So, "A" & "B" creates the string "AB".

 

[RicoJ]

Oh I see. Thank you so much for your help! It's very clear! Have a good day!

Rico