Hi Peter,

Your post isn't very clear.
In your example.

You can copy A2
Select A1 to D1
Right click on the selection
Pick Paste Special
Check multiply
And OK out.

That does what you seem to be saying but I suspect
you are trying something beyond that.


HTH
Martin

"Lion2004" wrote in message
...
I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter