How can I get a macro in Excel to delete Rows 1 to 6?

What macro can I insert in Excel which will delete Rows 1 through 6?
100questionsAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
This will delete rows 1 to 6 on the active sheet.
Range("1:6").Delete

Open in new window

This will delete rows 1 to 6 on a specific sheet, Sheet2 in this example.
Sheets("Sheet2").Range("1:6").Delete

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.