Delete Row
 

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

Delete Row
 

sub DeleteRows()

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

end sub

"bijan" wrote:

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