Thread: variable declaration for more than one worsheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default variable declaration for more than one worsheet
Hi Alberto

Worth reading this article
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

Public strData As String

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

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

Reply With QuoteReply With Quote