none
How to clear cell contents from 4th row RRS feed

  • Question

  • Hi,

    I want to erase all data from Sheet3 except first 4 rows. I have some important data in first 4 rows that I never want to be deleted. I want a macro that will erase the whole worksheets except first 4 rows.

    Thanks. 

    Monday, June 22, 2015 7:04 PM

Answers

  • To remove the data but leave the formatting:

    Worksheets("Sheet3").Range("5:" & Worksheets("Sheet3").Rows.Count).ClearContents

    To remove the data AND the formatting:

    Worksheets("Sheet3").Range("5:" & Worksheets("Sheet3").Rows.Count).Clear


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Ed_Dao Wednesday, June 24, 2015 8:51 PM
    Monday, June 22, 2015 7:19 PM