Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to define such items as
public ws as worksheet public rg as range I put them in the general declarations for "This Workbook". All other variables such as integer, string etc. are behaving as global. But not the objects. I read some discussion about defining them as I indicated above, but when I go to another module, it gives me the error that the name is not defined. Can objects be global? If so, is there a certain place they have to be defined |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Global Variables | Excel Programming | |||
Excel loses mind clearing VBA global variables | Excel Programming | |||
Global Variables in Excel VBA | Excel Programming | |||
Global Variables | Excel Programming | |||
Global Variables | Excel Programming |