Excel - Delete row in unselected worksheet

[TorF]

In excel 2000, I try to delete a row in an unselected worksheet.

Actually, i use the following vb code:
Rows(1).Select
Selection.Delete Shift:=xlUp
This deletes the first row of the active worksheet.

How can I do to supress the row in an unactive worksheet ?
(If possible without activating it)

Thanks

 

[RobBroekhuis]

sheets("MyInactive&quot.rows(1).delete shift:=xlUp

Rob

 

[xlbo]

Or, just as another example (Rob's will work perfectly well)use the WITH construct
with sheets("MyInactive&quot
.rows(1).delete shift:=xlUp
end with


Rgds
~Geoff~

 

[TorF]

Ok that works fines.

I need to read an excel manual...