Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable declaration for more than one worsheet
How do I declare a variable so it will work on more than one worksheeet while
using macros among both worksheets. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable declaration for more than one worsheet
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Public variable declaration | Excel Programming | |||
Variable Declaration | Excel Programming | |||
VBA - variable declaration | Excel Discussion (Misc queries) | |||
variable declaration | Excel Programming | |||
Variable Declaration?? | Excel Programming |