I've got an Excel file I'm working on in which I've got some dynamic arrays I need to use. I have them declared up in Option Explicit, and their size is first defined in my main function.
Code:
Option Explicit
    Dim array_temp() As Integer
    Dim array_rt() As Integer

Sub DrawSignal()
    ReDim array_rt((num_results + 1), (num_results)) As Integer
    ReDim array_temp(num_results + 1) As Integer
End Sub
Unfortunately, I need to use them again in multiple functions, but for some reason they keep coming up as Invalid Qualifiers. I've tried using ReDim Preserve to reset the size while still keeping the data, but it's still giving the same error. How can I get it to recognize the arrays?