using adjusted paste special / multiply in VBA

[Hein]

Hi all,

How can I multiply a variing range with 1, to make sure that numbers are treated as numbers.
Now i find that sometimes numbers are regarded as text, which influences the outcome of my rank formula.

the range = rngInput (which varies)
the multiplyfactor = 1

I am trying to use the paste special, multiply option, but don't know how to adjust the formula to my purposes
This formula is:
Selection.PasteSpecial paste:=xlPasteAll, Operation:= xlMultiply, _
skipblanks:=False, Transpose:= False

Who knows what tot do?

Thanks in advance

Hein

PS
Maybe there is another way which is more efficient?

[TMS]

Example:

Please Login or Register  to view this content.

so, in this case:

Please Login or Register  to view this content.

Regards

[shg]

Try this:

Please Login or Register  to view this content.

[Hein]

Thanks shg
Your tip did the trick
I didn't get the 1st tip to work, but yours did!

Hein

PS
Sorry for the deleyed answer!