No data from another macro in another module

[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

 

[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.

 

[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