matarillo #7545(2008/09/01 20:22 GMT) [ Other ] Rating0/0=0.00
VBA for Excel (2003)
1 2 3 4 5 6 7 8 9 10 11 12 13 14
Sub Main() n = Val(InputBox("")) m = 0 p = 0 Do Range("A1").Offset(p) = m If m = n Then Exit Do End If l = Len(Str(m)) - 2 m = m + 10 ^ l p = p + 1 Loop End Sub
Rating0/0=0.00-0+
[ reply ]
matarillo
#7545()
[
Other
]
Rating0/0=0.00
VBA for Excel (2003)
Sub Main() n = Val(InputBox("")) m = 0 p = 0 Do Range("A1").Offset(p) = m If m = n Then Exit Do End If l = Len(Str(m)) - 2 m = m + 10 ^ l p = p + 1 Loop End SubRating0/0=0.00-0+
[ reply ]