Using variables for row numbers

[Madingo]

Hello i have a simple question. How do you call a row using a variable? Example
Rows("1:1").select

Using Rows("count:count").select doesn't work. Any Help would be appreciated.

Bill Mahoney

 

[Barrie Davidson]

On 2002-03-20 11:06, Madingo wrote:
Hello i have a simple question. How do you call a row using a variable? Example
Rows("1:1").select

Using Rows("count:count").select doesn't work. Any Help would be appreciated.

Bill Mahoney

Bill, something like:

Dim RowNumber1 As Long
Dim RowNumber2 As Long
RowNumber1 = 65
RowNumber2 = 67
Rows(RowNumber1 & ":" & RowNumber2).Select

Regards,

 

[Madingo]

Thanks for the help. I finally figured it out.

using Rows(Count).Select

works just fine.