How to increment values contained in a Variant and to put in a Range

**JohnM3** · 06-12-2012, 09:09 AM

This works:

Please Login or Register  to view this content.

What I want is (to the effect)
v = WS_Sales.Range("C93:C105").Value
v = v * 1.10
WS_Sales.Range("C80:C92").Value = v

I do NOT want to loop the elements inside of v - but
don't see anyway to avoid the issue.

Is there some other "one and done" approach?

regards
John

**buran** · 06-12-2012, 09:27 AM

not very nice, but you can put the constant (i.e. 1.1) in a cell and use copy-> paste special multiply on range C80:C92
IMHO loop is better

**mikerickson** · 06-12-2012, 09:49 AM

Please Login or Register  to view this content.

**JohnM3** · 06-12-2012, 10:10 AM

mikerickson

Oh My God!

Perfect!

I am blown away. And I hope it helps someone else along the way.

I don't understand it - but I will "get it" - just need some time.

It is truly - ONE AND DONE.

**Cannot** thank you enough.

Also - Buran - thank you for responding to my post.

regards
John