Thread: keep a variable from one function to another

Hi all, On my program, I have three functions are: Sub Worksheet_Change (ByVal Target As Range) which performs a first seizure saisie2 sub () that allows manual entry of the remaining cells calculation sub () that performs the calculations according to information previously met the problem is: I use the Worksheet_Change function i = Target.Row to have the selected row => date_travaux = Rang, However, the value of i disappears as soon as I leave my job Sub Worksheet_Change . What's the reason? I counter this problem and if so how? Thank you for the attention and good luck

Hello, I was somewhat missing these days , Have you solved your problem? There are two ways to resolve this issue but we should learn more about how you leave the Sub Worksheet_Change and how you call saisie2 () and calculated () A small demo file attached would be welcome.

Hello, You're in a sub, you defined in your variables? for as the saying galopin01, there are two ways: Or you set your variable i in public, but in this case i will be used in all your subs (like all other variables would you have said in public). therefore, we must be careful in the choice of these variables public Or you use a function instead of a sub for you that it returns the value