Can excel objects be defined as global variables



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
Can objects be global? If so, is there a certain place they have to be

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question