Check this for an alternate way...
If you wan all code to remained in Sheet module then you can take only
Public variable in separate Module.
Cheers!!
On Wed, Mar 25, 2015 at 4:48 PM, Vaibhav Joshi wrote:
> Hi
>
> your method is correct, only error you did is u showed it in worksheet
> module
Hi
your method is correct, only error you did is u showed it in worksheet
module (which is pvt module by default), you need to create separate module
and add code in to it..
See attachment.
Cheers!!
On Wed, Mar 25, 2015 at 4:19 PM, Rohit Jadhav wrote:
> Thanks a lot. It definitely solves my p
Thanks a lot. It definitely solves my problem. Can you please tell me how
to declare array using public keyword.
On Wednesday, March 25, 2015 at 4:10:48 PM UTC+5:30, Rohit Jadhav wrote:
>
>
> Hi
> I have a simple question
> I'm trying to declare a public array myarray which can be used by either