Thread: help me...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Young-Hwan Choi Young-Hwan Choi is offline
external usenet poster
 
Posts: 17
Default help me...

When I run the code below, it writes 0, 0.1, and 0.2. It doesn't write the
last one, 0.3.
If I change 0.3 to 0.6, it writes 0 to 0.5, not 0.6.
What's wrong with it?
(I recall someone said about dim, or something regarding this... but, I
don't know ...)

Sub test()
For i = 0 To 0.3 Step 0.1
ActiveCell.Offset(1, 0).Activate
ActiveCell = i
Next i
End Sub

thanks