"rows" syntax
 

The following selects rows 1 and 2:

Sub Row_Select()

Rows("1:2").Select

End Sub


--
Michael J. Malinsky


"Claude" wrote in message
...
I would like to select a range of rows as follows:
Rows(a,b).Select
Can anybody help me with the correct syntax? Thanks!

"rows" syntax
 

I would like to select a range of rows as follows:
Rows(a,b).Select
Can anybody help me with the correct syntax? Thanks!

"rows" syntax
 

Hi
one way:
Range(Rows(a),rows(b)).select

--
Regards
Frank Kabel
Frankfurt, Germany

Claude wrote:
I would like to select a range of rows as follows:
Rows(a,b).Select
Can anybody help me with the correct syntax? Thanks!

"rows" syntax
 

Hi Claude,

rows("1:5").select


if a and b are variables then

rows(a & ":" & b).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Claude" wrote in message
...
I would like to select a range of rows as follows:
Rows(a,b).Select
Can anybody help me with the correct syntax? Thanks!

"rows" syntax
 

Thanks Frank, this is what I was looking for...

-----Original Message-----
Hi
one way:
Range(Rows(a),rows(b)).select

--
Regards
Frank Kabel
Frankfurt, Germany

Claude wrote:
I would like to select a range of rows as follows:
Rows(a,b).Select
Can anybody help me with the correct syntax? Thanks!
.