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


---
Message posted from http://www.ExcelForum.com/

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)

"Blewyn " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

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

But a quicker way:
Rows(Count).Select

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Blewyn " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

Great, thanks

--
Message posted from http://www.ExcelForum.com