Global variables
 

How can I set up a global variable like:

Public lh as Integer

???

Global variables
 

Put it in a standard module before any subs for udf's
--
Gary's Student


"Ed" wrote:

How can I set up a global variable like:

Public lh as Integer

???

Global variables
 

In general, global variables are not necessary, and if possible are best
avoided. Why do you think you need one?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...
How can I set up a global variable like:

Public lh as Integer

???

Global variables
 

Ed,

You do it exactly the way you have it below. Just be sure you have it in a
regular code module (in the VBA editor, Insert menu, Module). Don't put the
variable declaration in an object module (ThisWorkbook, the Sheets, a
UserForm, or a Class module).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

"Ed" wrote in message
...
How can I set up a global variable like:

Public lh as Integer

???

Global variables
 

Thanks for reply. I'll be using the calculated variable to be used in
a procedure that would will be run 55 times. Rather than calculate it
55 times, I calculate it as once as a public.



On Sun, 19 Nov 2006 17:14:47 -0000, "Bob Phillips"
wrote:

In general, global variables are not necessary, and if possible are best
avoided. Why do you think you need one?

Global variables
 

Thanks for a code module did the trick. thanks again.

Ed English



On Sun, 19 Nov 2006 11:42:13 -0600, "Chip Pearson"
wrote:

Ed,

You do it exactly the way you have it below. Just be sure you have it in a
regular code module (in the VBA editor, Insert menu, Module). Don't put the
variable declaration in an object module (ThisWorkbook, the Sheets, a
UserForm, or a Class module).

Global variables
 

Did that and solved the ptoblem. Thanks for replying.


Ed English



On Sun, 19 Nov 2006 08:51:02 -0800, Gary''s Student
wrote:

Put it in a standard module before any subs for udf's