Clear Column Contents

[adamsm]

Hi,

How could I write a code that would delete the column contents from C11:N101 and hide rows 103 to 123 ?

Any help on this would be kindly appreciated.

Thanks in advance.

 

[littleiitin]

Sub ClearandHide()
    Range("C11:N101").Clear
    Range("A103:A123").EntireRow.Hidden = True
End Sub

 

[adamsm]

Thanks for the reply. The code clears the values. But in doing so it even clears the lines that I have placed in rows. How could the code be made so that it only clears the data values but not the line?

Thanks in advance.

 

[CWatts]

If you want to keep formats change the .Clear to .ClearContents

Sub DoStuff()
     Range("C11:N101").Clear
     Rows("103:123").Hidden = True
End Sub

 

[adamsm]

Thanks for the help. How could this code further be made so that it un hides rows from 11:101?

 

[CWatts]

Just a quick alteration of the hide line to switch it around:


Rows("11:101").Hidden = False

 

[adamsm]

Thanks for the help. Really appreciate it.