Transformer
06-18-2013, 11:42 PM
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 […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=857&subd=usefulgyaan&ref=&feed=1
[url=http://usefulgyaan.wordpress.com/2013/06/19/avoid-loop-for-range-calculations-evaluate/]VBA Trick of the Week :: Avoid Loop for Range Calculations
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 […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=857&subd=usefulgyaan&ref=&feed=1
[url=http://usefulgyaan.wordpress.com/2013/06/19/avoid-loop-for-range-calculations-evaluate/]VBA Trick of the Week :: Avoid Loop for Range Calculations