Declaring Variables

Hi all,

The workbook I am using has a few add-ins with their own code hidden away. By chance, if I happen to use one of the variable names already declared within those, will I run into trouble?

I am currently declaring variables by;

Option Explicit

Sub sample()

Dim var_name As Integer

'Code

End Sub

Thanks

No. The scope of your variable is within the subroutine.


Regards, TMS

Variables will not impact variables in other projects, regardless of scope, so no need to worry about that.

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Glad to assist. Please do not forget to mark the thread solved.