Selecting a row with a variable ?

B

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
 
B

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)
 
R

Rob van Gelder

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

But a quicker way:
Rows(Count).Select
 
Top