推 ljuber: 用offset ? 11/16 11:09
→ andy4624: offset之後 怎麼寫要計算的儲存格? 11/16 12:09
→ andy4624: 抱歉我是新手 所以問題可能很基本 請再給指教 11/16 12:09
推 ljuber: range("b4").offset(,i-1_) 11/16 14:21
→ suaveness: Cells 在這個例子可能會比 Range 適合 11/16 14:47
→ waiter337: Sub test() 11/17 07:54
→ waiter337: For i = 1 To 4 11/17 07:54
→ waiter337: Select Case Cells(2, i) 11/17 07:54
→ waiter337: Case Is > 300: x = 0.08 11/17 07:55
→ waiter337: Case Is > 200: x = 0.07 11/17 07:55
→ waiter337: Case Is > 100: x = 0.06 11/17 07:55
→ waiter337: Case Is > 0: x = 0.05 11/17 07:55
→ waiter337: End Select 11/17 07:55
→ waiter337: Cells(4, i) = Cells(2, i) * x 11/17 07:55
→ waiter337: Next 11/17 07:55
→ waiter337: End Sub 11/17 07:55
→ andy4624: 謝謝樓上大大 11/17 10:03