Range Selection

S

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
 
R

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 *
 
N

Norman Jones

Hi Steve,

Try:

Rows("4:" & LastRow).Select


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