Another day - another baffling bug........
When i open an Excel workbook , i get the message " Complie error : Variable not defined
the variable is the array CompressedData() . The error comes up in the following code:-
- Code: Select all
Private Sub Compressor_DataAdd(DataStream, LongCol, MayBet)
Dim CompressLen As Integer 'DataStream As Integer, LongCol As Integer , MayBet As Single
CompressLen = dInput_ArraySize(DataStream) - 249 'NOTE : subtract 249 as function adds this on
If CompressLen = LongCol Then ' need to increase size of CompressedData() by 1
ReDim Preserve CompressedData(CompressLen + 1)
End If 'now add new equity change to last data in CompressedData()
CompressedData(DataStream, CompressLen + 1) = CompressedData(DataStream, CompressLen) + MayBet
End Sub
BUT - i have defined the array - at module level as
- Code: Select all
Public CompressorData() As Single
anyone got any ideas ?????