Simple Question but I can't seem to find the answer!!

[Overkill32]

I want to select a range of entire rows (for exemple Range("1:2").select) with whom i can identify the rows using a variable (for the purpose of the question, let's call the variables Row1 and Row2). So, if I was to decide that Row1=5 and Row2=9, I want to know how i can code the selection of the range using only the variable that i created .

Thank you in advance to whoever can answer me!

 

[leigao84]

Sub Macro1()
Dim Row1 As Integer
Row1 = 2
Range(Row1 & ":" & Row1).Select
End Sub

 

[shg]

You want to declare row variables as Long

    Dim iRow1 As Long
    Dim iRow2 As Long
    
    iRow1 = 7
    iRow2 = 5
    
    Range(Cells(iRow1, "A"), Cells(iRow2, "A")).EntireRow.Select
    ' or 
    Rows(iRow1 & ":" & iRow2).Select

 

[leigao84]

Oh right, with int you can't go past 2^8 rows. Silly me

 

[shg]

With Integer you can't go past 32768 rows (2^15).

 

[Peter_SSs]

Not related to the original question I know but..
I've pretty much given up using Integer at all. From http://msdn.microsoft.com/en-us/library/aa164754(v=office.10).aspx

In recent versions, however, VBA converts all integer values to type Long, even if they are declared as type Integer. Therefore, there is no longer a performance advantage to using Integer variables; in fact, Long variables might be slightly faster because VBA does not have to convert them.

 

[shg]

Agree, Peter.

And after converting to Long, they must have additional overhead in converting back and checking for overflow.

 

[Overkill32]

Thanks to all the quick answers! I didn't know how to structure the Range syntax to incorporate variables instead of direct references. This will surely make it easier for me!