using VBA to clear cell contents

[andrewb90]

Hello,

I feel like this is a dumb question, since I should know how to do this and can't remember. I need to clear the contents of multiple cells in the current sheet. I keep trying

Cells("D8:G8").Clearcontents

and that is clearly not it.
Any help in the correct direction would be greatly appreciated!

- Andrew

 

[Dazzawm]

How about

Range("D8:G8").Select
Selection.ClearContents

 

[Rick Rothstein]

How about

Range("D8:G8").Select
Selection.ClearContents

Very rarely do you have to select something in Excel in order to do something with it. Your suggested code can be written compactly like this...

Range("D8:G8").ClearContents

Think about it... you are clearing the contents of the Selection, but what is the selection? It is what you selected... Range("D8:G8"), so you might as well just clear what you selected directly and cut out the middle step.

 

[andrewb90]

Nice! You saved me from my crazy mind