網頁文章 網頁文章

 

 

 

網頁文章 網頁文章

 

 

 

網頁文章 網頁文章

 

Sub cell_sum()
 '計算D2:G2的總合放到H2儲存格中
 Range("H2").Value = "=SUM(D2:G2)"
 With Range("D2:G2").Font
                .Color = RGB(255, 0, 0)
                .TintAndShade = 0
 End With
 '取得儲存格的資料
 MsgBox Range("H2").Value
End Sub
 
網頁文章 網頁文章

 

Sub demo()
Dim x1 As Double
x1 = 5.5
Dim x2 As Boolean
x2 = True
Dim x3 As String
x3 = "Dahan"
Dim x4 As Variant
x4 = " Good "
MsgBox "變數:" & x1 & x2 & x3 & x4

End Sub


Sub ex01()
Static count_var As Integer
count_var = count_var + 1
tot_var = count_var * 5
MsgBox ("第" & count_var & "次呼叫,每次5元,共" & tot_var & "元")

End Sub
Sub js()
For i = 1 To 10
x = i
Range("a" & (i)).Value = i
Next i
End Sub
 

網頁文章 網頁文章