View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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

???