Range Selection

[ssmith]

OK, I want to select a range of rows. The first row is a number and th
last row numjber is a variable. How can I mix the 2 types? I tried

Rows("4:Lastrow").Select

But I get a type mismatch.

Thanks,
Stev

 

[Rob Bovey]

Hi Steve,

This should work:

Rows("4:" & LastRow).Select

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Norman Jones]

Hi Steve,

Try:

Rows("4:" & LastRow).Select


You may well be able to derop the Select - it is rarely necessary.