Selecting rows
 

If I want to select rows 1 to 15, the syntax is:

rows("1:15").select

What if I want to select rows 1 to i where i is an integer?

Thanks!

Selecting rows
 

rows("1:" & i).select

tim

"Shatin" wrote in message
...
If I want to select rows 1 to 15, the syntax is:

rows("1:15").select

What if I want to select rows 1 to i where i is an integer?

Thanks!

Selecting rows
 

Tim,

Many thanks for such a prompt reply!

"Tim Williams" <saxifrax@pacbell*dot*net wrote in message
...
rows("1:" & i).select

tim

"Shatin" wrote in message
...
If I want to select rows 1 to 15, the syntax is:

rows("1:15").select

What if I want to select rows 1 to i where i is an integer?

Thanks!