Multiplying each cell in a selection by a variable

[Bishonen]

Hi all,

very easy one incomming: I want to code the equivalent of selecting a cell and copying it, then making another selection and pressing ctrl+alt+v and chosing multiply.

I can do it by :

Please Login or Register  to view this content.

But as many of you know, this takes ages compared to a simple paste/multiply.

I'm sure there is a easy solution how to multiply a whole selection by a value.

Thanks

[tigeravatar]

Bishonen,

Use the Range.PasteSpecial method:

Please Login or Register  to view this content.