No data from another macro in another module

  • Thread starter Thread starter Madiya
  • Start date Start date
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
 
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
Click to expand...

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

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

Mick.
Click to expand...


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

Thanks.
Madiya
 
Back
Top