How to clear specific cells

[moheganburner]

How can I just clear a specific range of cells? "ToSheet.Cells.ClearContents" is the only one I know and that clears the whole sheet. I have tried to modify it, but no luck.

Also, how can I add a line in my code that puts "Joe" in cell B4?

Thanks!
MB

 

[Greg Truby]

<ul>[*]ToSheet.Range("B2:E7").ClearContents[*]Range("B4") = "Joe"[/list]Notes:

1. This assumes that ToSheet is a worksheet object variable that has been set.
2. The second example's syntax does not specify which worksheet, therefore it would put the value in cell B4 on the active worksheet.

 

[sykes]

answer to part 1:

Sub clear_stuff()
Sheets("sheet1").Range("A1:B2").ClearContents
End Sub

answer to part 2:

Sheets("sheet1").Range("B4").value="Joe"

Obviously substitute the correct sheet refs etc etc

 

[moheganburner]

Awesome! Thanks guys!

MB