Deleting all lines on an Excel spreadsheet through VB

Experts,

Can someone help me with code to delete all the rows on an Excel spreadsheet except the header row in VB.
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
This will delete all but Row 1 of the active worksheet...

Range(Cells(2, 1), Cells(Rows.Count, 1)).EntireRow.Delete
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.