View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucy Pearl Lucy Pearl is offline
external usenet poster
 
Posts: 4
Default Square Root in VBA

I cannot make the sqr work in VBA:

Function test1() As Variant
test1 =
Application.WorksheetFunction.MMult(Application.Wo rksheetFunction.MMult(RegionR, CovarMatrix), Application.WorksheetFunction.Transpose(RegionR))
End Function

RegionR is Variant with 6 objects
CovarMatrix is Variant with 6 x 6 objects

Anyone know a shortcut?