mohadin Active Member Sep 29, 2015 #1 Hi gents, Is there a way to keep a variable value in a macro to be used in other macros thanks sorry for this mistake,wrong address forgive me
Hi gents, Is there a way to keep a variable value in a macro to be used in other macros thanks sorry for this mistake,wrong address forgive me
Deepak Excel Ninja Sep 29, 2015 #2 Read it. http://www.ozgrid.com/VBA/variable-scope-lifetime.htm http://www.functionx.com/vbaexcel/functions/Lesson3.htm http://www.vbforums.com/showthread....etween-Dim-Private-Public-Global-Static-Const
Read it. http://www.ozgrid.com/VBA/variable-scope-lifetime.htm http://www.functionx.com/vbaexcel/functions/Lesson3.htm http://www.vbforums.com/showthread....etween-Dim-Private-Public-Global-Static-Const
mohadin Active Member Sep 29, 2015 #3 Thank you sir and I.m realy sorry for that it was by mistak If I might go more in thus issu what I want now is to use the last value for a variable in macro "a" and use this value in macro "b" for example
Thank you sir and I.m realy sorry for that it was by mistak If I might go more in thus issu what I want now is to use the last value for a variable in macro "a" and use this value in macro "b" for example
Deepak Excel Ninja Sep 30, 2015 #4 Pls spare some time to read the articles on the link as same help to clear the concept too.
