Question: How to calculate the means value of the Range(B4:B10) and transfer to the range in my excel file~~
http://img519.imageshack.us/my.php?i...5760948lb8.jpg
Also my vba command are show below:
[VBA]Private Sub cmdAnalysis_Click()
Dim wb As Workbook
Set wb = ThisWorkbook
Workbooks.Open Filename:=Me.ListBox1.List(Me.ListBox1.ListIndex)
If ListBox2.Value = ("115 Vac 60 Hz") Then
Range("B4:B10" / 7).Select
Selection.Copy
wb.Activate
Range("c4").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End If
End Sub[/VBA]
http://img519.imageshack.us/my.php?i...1184488jr3.jpg
Of course the Range("B4:B10" / 7) is impossible in vba. Therefore, i want to get this value, then transfer to the range in my excel file~~
P.s. i am the beginner of the VBA~~That' why i have many questions~~Sorry