arielon
03-09-2009, 12:41 AM
hello
I am a begginer in vba but I think I got the hang of it, in my lab we are using windows 2000, excel form 2002...
I dont understand why this code:
Sub t()
Range("c1").Value = Application.Vara(Range("a1:a5"))
End Sub
doesnt work. where, this code:
Sub t()
Range("c1").Value = Application.Var(Range("a1:a5"))
End Sub
does work. after all vara is just another statistical function supplied by excel.
the error message is 438 - doens't know the method. but I can use it on excel sheets
thank you very much for whom ever tries to help
Arielon
I am a begginer in vba but I think I got the hang of it, in my lab we are using windows 2000, excel form 2002...
I dont understand why this code:
Sub t()
Range("c1").Value = Application.Vara(Range("a1:a5"))
End Sub
doesnt work. where, this code:
Sub t()
Range("c1").Value = Application.Var(Range("a1:a5"))
End Sub
does work. after all vara is just another statistical function supplied by excel.
the error message is 438 - doens't know the method. but I can use it on excel sheets
thank you very much for whom ever tries to help
Arielon