Delete Row

  • Thread starter Thread starter bijan
  • Start date Start date
B

bijan

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

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

end sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro on all files in a specific folder 3
Excel VBA help: Text file formatting 19
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Cut from one sheet, paste in another 2
Word VBA for deleting Selected Row 0
Loop Repeats - PLS HELP 2
Delete OLEObject from Row or Cell 4
clear all sheets code 4

Back
Top