Delete Row

[bijan]

Hi
I need a code to delete rows 1 to 8 in non-active sheet("test") without
select rows.
Thanks in advance

 

[Sam Wilson]

sub DeleteRows()

worksheets("test").rows("1:8").delete

end sub