"rows" syntax

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

The following selects rows 1 and 2:

Sub Row_Select()

Rows("1:2").Select

End Sub
 
I would like to select a range of rows as follows:
Rows(a,b).Select
Can anybody help me with the correct syntax? Thanks!
 
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)
 
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

.
 
Back
Top