Thread: Delete Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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