
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
"P. Lui" <[EMAIL PROTECTED]> wrote... ... >Dim count, start_time, num_station, last_entry, output_row, _ >num_time_interval As Long VBA is not C. In this variable declaration, only num_time_interval is declared as a Long (integer). All the other variables are Variants (the default type). Is that what you intended? > Cells(output_row + t + 1, station + 1).Value = acc_pcp / count >'<--this line is highlighted when I press debug > Cells(output_row + t + 10, station + 1).Value = count I'll guess you mean the line above this comment. Hard to say without seeing the values. Precede the statement with the following two statements. Debug.Print acc_pcp Debug.Print count What are these respective values?
| <-- __Chronological__ --> | <-- __Thread__ --> |