variable declaration for more than one worsheet

A

Alberto Ast

How do I declare a variable so it will work on more than one worksheeet while
using macros among both worksheets.
 
J

Jacob Skaria

From VBE menu 'Insert' a module and paste the below declaration..

Public strData As String

If this post helps click Yes
 
Top