Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: Need help on Overflow Error '6'



"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__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.