Changing multiple cells

[eddd82]

Just a simple question here. How do i change multiple cells in the one statement or does it have to be done as below:
Sheets("Sheet1").Range("F4").Value = newValue
Sheets("Sheet1").Range("F8").Value = newValue

 

[Ricky Morris]

Try this:

application.Union(range("a1"),range("a5")).Value = newvalue