UsefulGyaan Has Posted the Following On 06-19-2013 12:01 AM:

At times*we*need to change cell values in a range based on a calculation. The most common way of doing it is using loop. e.g. *We have numeric data in range A1:B10 of Sheet1 and we need to multiply all cells of this range by 2. Sub Test() Dim rngData As Range Dim rngCell As Range […]

[url=http://usefulgyaan.wordpress.com/2013/06/19/avoid-loop-for-range-calculations-evaluate/]VBA Trick of the Week :: Avoid Loop for Range Calculations