No data from another macro in another module

M

Madiya

I am using J-Walk's RemoveDuplicates code in module A. It is called from sub same() and works fine.

When I tried to call the same RemoveDuplicates code from another module B, from sub newmacro() it does not return the data. It returns 0 value. when I check the count of items in nodups it was 304 nos and when i checked the same in my sub count is zero.


Can you pl help?

Regards,
Madiya
 
V

Vacuum Sealed

I am using J-Walk's RemoveDuplicates code in module A. It is called from sub same() and works fine.

When I tried to call the same RemoveDuplicates code from another module B, from sub newmacro() it does not return the data. It returns 0 value. when I check the count of items in nodups it was 304 nos and when i checked the same in my sub count is zero.


Can you pl help?

Regards,
Madiya

It would be much easier to help if we could see your overall code to
determine why an then move forward.

Mick.
 
M

Madiya

It would be much easier to help if we could see your overall code to
determine why an then move forward.

Mick.


Mick,
Thanks for reply.
But I have figured it out. Its declaring those variables as public and alsosub as public.

Thanks.
Madiya
 

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

Top