Range maths function

[cwng3]

Hi,

I want to mulitiple each element in the range by 100. How can I do it ?

I want to see if any way to avoid looping.

Thanks

TT

 

[Tazguy37]

Put 100 in a cell by itself.
Copy it.
Select the range of cells you want to multiply by 100.
Select Edit, Paste Special, Multiply.

You're done.

Hope that helps!

 

[cwng3]

Thank you. But is it the only way. I dont prefer to use copy/paste in marco.

 

[Tazguy37]

That's the only way I can think of doing it without looping through each cell you select to multiply.

 

[cwng3]

ic thank you.