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?
Who is Participating?
NorieVBA ExpertCommented:
This will delete rows 1 to 6 on the active sheet.

Open in new window

This will delete rows 1 to 6 on a specific sheet, Sheet2 in this example.

Open in new window

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.