VBA set cell rangs values to 0

[cranebill]

I have a statement that clears the contents of cells...

Range("I7:I8").ClearContents

How would I write something that would populate each cell in the range with a zero?

 

[SkipVought]

Hi,

Range("I7:I8").Value = 0

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

BTW, please post further VBA questions in Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

For future reference, please post VBA-specific questions in forum707.

Range("I7:I8") = 0

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.