Vba that deals with noncontiguous range

[twl2009]

Hi,

I have the simple bit of code below, that add or removes a percentage of cells value. I need to apply this to quite a large number of cells that wont be a contiguous range, is there an easy way of doing this with writing the same line many times?

Sub SalesSeasons()
       Worksheets("SalesForecast").Range("H17") = Range ("H17").Value*Range("X6").Value
End Sub

 

[Peter_SSs]

This limit (",2") is very interesting! I never used before. Also this "Address(0, 0)" is nice one My codes are full of Address(false, false)...

Thank you very much Peter. Sure I will use this way with pleasure!

Cheers, you're welcome.