How to put a selected range into a formula

[Paultje]

I want to write a macro that puts two selections the user made before starting the macro into a formula
Like selections a1:a5 and b1:b5

the macro should fill c1 with
slope(a1:a5;b1:b5)
i can't get this to work with range("c1").formula=

Anyone any idea ?

Paul

 

[gnaga]

I am using like this

Range("C1").Value = "=Slope(A1:A5,B1:B5)"

it works

GNaga

 

[Paultje]

probably i didn't make myself clear.

what i want is this:
the user selectes 2 ranges and starts the macro

the macro puts the two selected ranges in two variabel, which are declared as ranges ,with

sel1=application.selection.Item(x)

then the macro should make the formula in cell c1 like =slope(sel1;sel2) where sel1 and sel2 are replaced with the ranges they contain

= "=Slope(A1:A5,B1:B5)"

Paul