ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiply a Range by a Constant (https://www.excelbanter.com/excel-programming/317591-multiply-range-constant.html)

Jim Thomlinson[_3_]

Multiply a Range by a Constant
 
I would like to multiply a range by a constant. My range is Target

Target.value = [Target.value] * sngPercent

is what I have but it doesn't work. Any suggestions besides traversing the
range one element at a time?

Thanks In Advance...



All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com