[VBA ] 請問一個變數宣告的問題
↓以下是新手小弟寫的小程式↓
--------------------------------
Sub test()
Dim i As Double, j As Double, k As Double
Dim i1 As Double, i2 As Double, i3 As Double, j1 As Double, j2 As Double,
j3 As Double, k1 As Double, k2 As Double, k3 As Double
Worksheets("sheet1").Activate
i1 = 3
i2 = 4
i3 = 0.02
j1 = 8
j2 = 9
j3 = 0.5
k1 = 1.5
k2 = 3
k3 = 0.5
For i = i1 To i2 Step i3
For j = j1 To j2 Step j3
For k = k1 To k2 Step k3
Worksheets("sheet1").Cells(1, 1).Value = i
Worksheets("sheet1").Cells(1, 2).Value = j
Worksheets("sheet1").Cells(1, 3).Value = k
Next k
Next j
Next i
End Sub
--------------------------------
我的問題是，我跑出來的結果一直卡在儲存格A1的值竟然是3.98而不是4？
所以請問各位先進這個問題是錯在哪？並請問該怎麼改呢？
此外，變數宣告我也曾經用過"single"可是儲存格A1的值更怪變成了3.99999
請問這是什麼原因呢？
--
麻煩大家指教了<(_ _)>
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.223.97.36
推
03/03 02:44, , 1F
03/03 02:44, 1F
→
03/03 02:44, , 2F
03/03 02:44, 2F
→
03/03 02:45, , 3F
03/03 02:45, 3F
→
03/03 02:45, , 4F
03/03 02:45, 4F
→
03/03 02:46, , 5F
03/03 02:46, 5F
推
03/03 07:04, , 6F
03/03 07:04, 6F
→
03/03 07:05, , 7F
03/03 07:05, 7F
推
03/03 07:06, , 8F
03/03 07:06, 8F
推
03/03 07:07, , 9F
03/03 07:07, 9F
推
03/03 07:31, , 10F
03/03 07:31, 10F
→
03/03 07:32, , 11F
03/03 07:32, 11F
→
03/03 07:33, , 12F
03/03 07:33, 12F
→
03/03 07:33, , 13F
03/03 07:33, 13F
推
03/03 09:01, , 14F
03/03 09:01, 14F
推
03/03 12:21, , 15F
03/03 12:21, 15F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇)：
7
15
Visual_Basic 近期熱門文章
PTT數位生活區 即時熱門文章
33
68