We help IT Professionals succeed at work.

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

Member_2_5306354
Member_2_5306354 asked
on
What macro can I insert in Excel which will delete Rows 1 through 6?
Comment
Watch Question

Analyst Assistant
Commented:
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