提供一個很蠢的方法~
先定義名稱 B1 牛肉;B2 羊肉....以此類推
Sub ptt()
Dim MyName As Name
i = 10
For i = 1 To 8
Cells(i, 2).Name = Cells(i, 1).Value
Next
End Sub
E1=INDIRECT(E1)+INDIRECT(F1)+INDIRECT(Sheet1!G1)
Ptt:Excel不同組合對應數字加總
由 養花種魚數月亮賞星星 於 Friday, May 29, 2009
7:50 PM 發表
讀者回應 ( 0 意見 )
訂閱Post Comments (Atom)
Post a Comment
Please leave your name and tell me what you thought about this site. Comments, suggestions and views are welcomed.
如果這篇文章對你有幫助,那請留個訊息給我~