Selecting a row with a variable ?

[Blewyn]

How do I select an entire row by using a variable to store the row
number ? I currently have a statement which selects a range :

Range(Cells(Count, 1), Cells(Count, 16)).Select

but I'd like to select the entire row (row number is Count) instead...

Any ideas ?

Thanks,

Blewyn

 

[Bob Phillips]

Range(Cells(Count, 1), Cells(Count, 16)).Entirerow.Select

or even

Cells(Count, 1).EntireRow.Select

--

HTH

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

 

[Rob van Gelder]

I think you're looking for EntireRow
eg.
Cells(Count, 1).EntireRow.Select

But a quicker way:
Rows(Count).Select

 

[Blewyn]

Great, thanks