URGENT.. How to select a range 1

[bompa]

Hello Are in need for help with VBA for Excel 2002 (xp)
The problem is the following varStock and varMarket selects a number of cells.
However they doesn´t do that WHY?

Public Function CAPMBeta(varstock As Range, varMarket As Range) As Double

varVarians = Application.WorksheetFunction.Varians(varstock)
varCovarians = Application.WorksheetFunction.Kovarvarstock, varMarket)

CAPMBeta = CAPMBeta & varVarians / varCovarians
End Function

 

[Chance1234]

does this help ?

Public Function tstme(varstock As Range, varmarket As Range)


For Each Var In varstock
a = a + Var.Value
Next
For Each Var In varmarket
b = b + Var.Value
Next

tstme = a / b

End Function