"rows" syntax

[Michael J. Malinsky]

The following selects rows 1 and 2:

Sub Row_Select()

Rows("1:2").Select

End Sub

 

[Claude]

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

 

[Frank Kabel]

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

 

[Bob Phillips]

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]

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

.