B
Brad
I am working with a number of large VBA modules. Several times while
reviewing the code, I have hit the wrong key by accident and unintentionally
changed a line of code. Sometime later, I will try to use the module and I
receive the message “Variable Not Definedâ€. The problem is that because some
of these modules are quite large, it is very difficult to find the line of
code that I accidentally changed.
I have worked with several other programming languages over the years, but I
am new to VBA. All of the other languages that I have worked with in the
past would point out the offending line in a situation like this. Is there a
way to get VBA to explicitly tell which variable it is complaining about?
Thanks,
Brad
reviewing the code, I have hit the wrong key by accident and unintentionally
changed a line of code. Sometime later, I will try to use the module and I
receive the message “Variable Not Definedâ€. The problem is that because some
of these modules are quite large, it is very difficult to find the line of
code that I accidentally changed.
I have worked with several other programming languages over the years, but I
am new to VBA. All of the other languages that I have worked with in the
past would point out the offending line in a situation like this. Is there a
way to get VBA to explicitly tell which variable it is complaining about?
Thanks,
Brad