just when i thought i was getting near the end of debugging

[Fixador]

Hi All,

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 ?????

[Fixador]

oh crap ! I have spotted it

CompressedData()

isnt

CompressorData()

[PeteB]

If you add "Option Explicit" at the top of every file, the compiler will find things like this for you

[Fixador]

hi PeteB - yes , i have got that - it was just that the spelling was so close - i could not see what was bringing the 'yellow' line up