View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kensyo Kensyo is offline
external usenet poster
 
Posts: 1
Default "dim" problem after Service Pack Installation????

Today, I have this strange problem of dim. I don't have this problem before.
If I run the following program, variable d would automatically round up to
an integer. This happens to me any variable that I put at the end of the dim
statement if I have two or more variables.

Sub Button1_Click()
Dim a, b, c, d As Long
a = Range("c3")
b = Range("c3")
c = Range("c3")
d = Range("c3")
Range("c5") = a
Range("c6") = b
Range("c7") = c
Range("c8") = d
End Sub