A Alberto Ast Oct 27, 2009 #1 How do I declare a variable so it will work on more than one worksheeet while using macros among both worksheets.
How do I declare a variable so it will work on more than one worksheeet while using macros among both worksheets.
J Jacob Skaria Oct 27, 2009 #2 From VBE menu 'Insert' a module and paste the below declaration.. Public strData As String If this post helps click Yes
From VBE menu 'Insert' a module and paste the below declaration.. Public strData As String If this post helps click Yes
J Jacob Skaria Oct 27, 2009 #3 Hi Alberto Worth reading this article http://www.ozgrid.com/VBA/variable-scope-lifetime.htm If this post helps click Yes
Hi Alberto Worth reading this article http://www.ozgrid.com/VBA/variable-scope-lifetime.htm If this post helps click Yes
